Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Problem facing when using Above(), Multi Dimension

2017-01-20 18_40_34-Qlik Sense Desktop.jpg

As you can see from the picture, the line for "Large Corp" disappeared because of the usage of Above function.

I want to specific the calculation using above function refer to dimension "Quarter" and then split by Dimension "Size".

Is there any solution for this?

This is the formula of measure : (sum(Outstanding)-Above(Sum(Outstanding)))/Above(Sum(Outstanding))

1 Solution

Accepted Solutions
Highlighted

Try this:

Aggr((Sum(Outstanding) - Above(Sum(Outstanding)))/Above(Sum(Outstanding)), Size, Quarter)

View solution in original post

3 Replies
Highlighted

Try this:

Aggr((Sum(Outstanding) - Above(Sum(Outstanding)))/Above(Sum(Outstanding)), Size, Quarter)

View solution in original post

Highlighted

Or this:

Aggr((Sum(Outstanding) - Above(Sum(Outstanding)))/Above(Sum(Outstanding)), Size, (Quarter, (TEXT, ASCENDING)))

Highlighted
Not applicable

Thanks a lot. I gt it right.