Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have dimension of "Year" and have 10 different measures need to be evaluate of each year. How can I choose top 5 measures to be displayed based on value of those measures. Thanks
How are you trying to display these measures? Also, what measures are they?
Hey Saima,
Could you please explain your requirement more or you can saw us your desired output somehow?
hi,
are you using any chart to show your requirement? and in qlik view or qlik sense?
I want to use bar chart to display only top five measures ( out of all )against year dimension .
Aggr(Rank(Sum(Mesaure1)), Year)<=5
Aggr(Rank(Sum(Mesaure2)), Year)<=5
Aggr(Rank(Sum(Mesaure3)), Year)<=5
Aggr(Rank(Sum(Mesaure4)), Year)<=5
Look at the example I did. In the script you need to declare a flag for each year.