Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  General  Qlikview “Aggr” function equivalent in Microstrategy
Previous Previous
 
Next Next
New Post 1/27/2019 8:42 PM
User is offline Lianamelissa
1 posts
No Ranking


Qlikview “Aggr” function equivalent in Microstrategy 
Modified By Chris Adams  on 1/28/2019 11:43:08 AM)

Hi all, I'm trying to replicate the Qlikview Aggr function in microstrategy. I have the Qlikview code below, and what I think is the equivalent sql translation. The fields would be attributes in my data set. The idea is if you select a value from a filter in the dashboard it filters "where" clause in the metric. Is there a way to build parameters in to metrics in microstrategy? Or does anyone have a suggestion how to build an equivalent metric? I'm really scratching my head on the subquery part, I don't know if I could build that as a fact, and then build a metric from it?

Qlikview: Max({<Field1=>} Aggr(Sum({<Field2={'Value1'},Field3={'Value2'}, Field1=>} ThingCount), Field1)) SQL Equivalent: select Max(Value) from( select Sum(case when Field2 in ('Value1') and Field3 in ('Value2') and Field1 is not NULL then ThingCount end) as Value, Field1 from Table where Field1 = "FilterValue" group by Field1 )a

Thanks in advance.

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  General  Qlikview “Aggr” function equivalent in Microstrategy

Community Blog - Latest Posts

I have always loved cooking. I learned from my Grandma June and her kitchen was her sanctuary, a small, warm sunlit space filled with jars of spices, stacks of cookbooks, and the comforting smell of something always on the stove or baking in the oven. Grandma June was as great a cook as she was a teacher to me. She never followed a recipe “to...
Now, I know, I don’t know what kind of new intro BPO may require, but at least I can promise you upfront that I have something different to say about Business Process Outsourcing or simply BPO. What is it? This hasn't been a call center job or a sales job as we all think. It is a mammoth profile, and firms are grappling to ge...
Leveraging Blockchain Technology for Enhanced Data Security in Business Operations
In an age where data breaches and cyberattacks are becoming more frequent and sophisticated, businesses are searching for robust solutions to safeguard their data. Blockchain technology has emerged as a promising tool in this quest, offering a way to secure data with unparalleled reliability. Although initially known for powering cryptocurrencies l...

 






 

Copyright 2006-2025 by Modern Analyst Media LLC