Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator III
Creator III

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

Highlighted
Creator II
Creator II

Hey Saima,

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

Highlighted
Contributor III
Contributor III

hi,

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

Highlighted
Not applicable

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

Highlighted
Specialist
Specialist

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

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

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

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

Highlighted
Creator III
Creator III

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