Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Contributor II

Re: Display Top Five Measure out of Many Measures

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

ishanbhatt
Contributor II

Re: Display Top Five Measure out of Many Measures

Hey Saima,

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

pradnyan
New Contributor II

Re: Display Top Five Measure out of Many Measures

hi,

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

Not applicable

Re: Display Top Five Measure out of Many Measures

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

galax_allu
Valued Contributor

Re: Display Top Five Measure out of Many Measures

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
Contributor II

Re: Display Top Five Measure out of Many Measures

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