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 9: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

Gen1us2k
Gen1us2k
Most of the IT projects imply constant cooperation between the team members and customers. Although it might be often overlooked, the role and the importance of the client within the project is very crucial. Thus, it is in your interest to build a strong relationship based on trust. However, gaining trust on a single occasion is not a dealmaker &md...
0 Responses
emorphistechno
emorphistechno
Introduction In today's world, most enterprises work aggressively to achieve a higher level of business growth, which is made possible by leveraging one of the best automation technologies. One such technology is Robotic Process Automation (RPA) that plays a vital role in streamlining the customer experience in the most profitable manner.&nb...
0 Responses
Nick Stowers
Nick Stowers
Introduction   When I was introduced to scrum, the burndown chart was a tool that was highly emphasised however I feel the purpose has changed from it being a tool to predict (to a certain level) timescales for delivery to a tool that measures a team’s productivity…..in other words, the focus is on the number of points clear...
0 Responses






Latest Articles

Top Metrics for measuring Agile Project’s success
Aug 01, 2020
0 Comments
Good news is that the adoption of an agile approach is increasing with more and more projects being successful. As a business analyst / project manage...
Copyright 2006-2020 by Modern Analyst Media LLC