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

Heta Raval
Heta Raval
In a current scenario, when you are eliciting software service-based requirements then, you may be able to derive requirements in certain varieties. In the beginning, they can be just functional or non-functional requirements. But when you come across many other requirements as time goes, you can conclude requirements into several categories and wi...
0 Responses
Heta Raval
Heta Raval
It is essential to write an impressive approach which helps you to make a client convinced about your understanding of his requirement. The satisfactory approach would help you to be on the same page with the client. So, your chances to get the contract/project would raise. In order to provide a technical solution, a business analyst needs to recog...
1 Responses
Arash
Arash
Machine Learning (ML) models are intended to positively impact business efficiency. By understanding how these models are created, how they function, and how they are put into production, one can fully utilize their potential to make a difference in every day scenarios.   What is a Machine Learning Model? By creating cases within a narrow d...
0 Responses




Latest Articles

Six Estimation Safety Tips
Oct 13, 2019
0 Comments
Estimation is a chronically thorny issue for software practitioners. Most people need to prepare estimates for the work they do, but in our industry w...
Copyright 2006-2019 by Modern Analyst Media LLC