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

Display Top Five Measure out of Many Measures

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

6 Replies
joshrussin
Creator III
Creator III

How are you trying to display these measures? Also, what measures are they?

ishanbhatt
Creator II
Creator II

Hey Saima,

Could you please explain your requirement more or you can saw us your desired output somehow?

Anonymous
Not applicable
Author

hi,

are you using any chart to show your requirement? and in qlik view or qlik sense?

Not applicable
Author

I want to use bar chart to display only top five measures ( out of all )against year dimension .

Anonymous
Not applicable
Author

Aggr(Rank(Sum(Mesaure1)), Year)<=5

Aggr(Rank(Sum(Mesaure2)), Year)<=5

Aggr(Rank(Sum(Mesaure3)), Year)<=5

Aggr(Rank(Sum(Mesaure4)), Year)<=5

joshrussin
Creator III
Creator III

Look at the example I did. In the script you need to declare a flag for each year.