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

Rajesh-N
Rajesh-N
What Everyone Must Know about AI in Testing Artificial Intelligence is the buzzword that we frequently keep hearing. Its widespread popularity and influence can be understood from the way industries adopting AI in their organization. Whether it’s Healthcare, Automobile, Banking & Financial Services, or Airlines, many industries have st...
0 Responses
Ashish Adike
Ashish Adike
As a Business Analyst, very often we get into a situation where the Project requires multiple IT Products to be evaluated before implementation and might seek Business Analyst’s recommendation for the same. With the ever-growing range of Products in the market and the marketing promotions associated with some of the products, it’s very ...
0 Responses
m_anst
m_anst
What Does Success Look Like? I challenge Business Analysts to view requestors’ requirements as an opportunity to define success. Too often, teams fall into a trap focused on requestors’ prescriptive requirements that are meant to serve as roadmaps for developers and testers. When you limit your view of requirements to this prescripti...
0 Responses






Latest Articles

The Art of Letting Stakeholders Have Your Way
Nov 23, 2020
0 Comments
Study after study in behavioral science show that certain approaches are more effective than others when we’re trying to convince others to see ...
Copyright 2006-2020 by Modern Analyst Media LLC