Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  General  Qlikview “Aggr” function equivalent in Microstrategy
Previous Previous
 
Next Disabled
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 Disabled
  Modern Analyst Forums  Business and Sy...  General  Qlikview “Aggr” function equivalent in Microstrategy

Community Blog - Latest Posts

Ekaterina Barabash
Ekaterina Barabash
I address my thoughts to those who are in IT management for whom the terms such as quality of project implementation development and profitability indicators of the company are important.  And it is also addressed to business analysts whose daily routine is the process of communication with Customer. A little about myself first. The last 8...
1 Responses
Dan Tasker
Dan Tasker
I have long been a believer in the saying “Context is everything.” As a business analyst dealing with business users, understanding the context of the topic of discussion is essential. In thinking about what constitutes quality requirements it occurred to me that there are a number of additional contexts that play a role. Examples inclu...
2 Responses
Alexey Kiselev
Alexey Kiselev
We are writing User Stories to fix the scope and describe - what our application should do when implemented.User Stories are great, because the are: Short, Defining Roles, A great connection of the requirement itself and a business need. User Story declared as a high level definition of the requirement, but it could be used to s...
0 Responses




Latest Articles

Do Business Analysts Need to Know SQL????
Feb 06, 2019
0 Comments
While many business analysts may be able to get by without ever writing a single line of code, the ability to write and interpret SQL queries can grea...
Featured Digital Library Resources 
Copyright 2006-2019 by Modern Analyst Media LLC