Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression on TopX Dimension

Hello,

I'm showing a simple SUM(Measure) by a dimension A.

Now i would also like to show the SUM(Measure) for only for the TopX SUM(anotherMeasure) by dimension B ignoring dimension A

any suggestion

3 Replies
Not applicable
Author

if A is the dmension of your chart, and your X is 3, is :

sumif ( anothermesure >=  max( total  anothermesure , 3) , mesure ))

OK ?

(i'm not sure what is your dimension B in this context)

Gysbert_Wassenaar

variable vTopX: 5

dimension: DimA

expression: sum({<DimB={"=rank(sum({<DimA=>}MeasureB))<=$(vTopX)"}>}MeasureA)


talk is cheap, supply exceeds demand
Not applicable
Author

I was trying to do sth like that but was unable to find how to.

Very nice formula !