only show top 5 values in a chart

[#1]

Hi, I have a bar chart that is showing count(field1) as expression. I want to just show the first top five (the biggest numbers) and don't show the rest. How should I do this in qlikview

[sunny_talwar]

May be like this:

If(Rank(Count(field1), 1, 1) < 6, Count(field1))

[narendiran]

Hi,

You can do this simply in a front end by limiting the dimension, please see the below pic

[#4]

This works, but it is still showing the other dimensions in the chart but with blank bars. Is there a way to fix it?

[jaspal_icon]

Hello ,

It should b easy, go to Chart properties in Dimension limits, and select option largest 5, and uncheck "other" in bottom side so that no other come.

Hope it will be useful, let me know if not.

Thanks

[narendiran]

Un tick show others

[sunny_talwar]

Have you suppressed zero?

[Anonymous]

Hi

Please provide the Dimension name as well

or

try this  in DIMENSION

=If(Aggr(Rank(count(field)), DIMENSIOFIELD)<=5, DIMENSIOFIELD, Null())

and

mark  the

supress when value is null

[#9]

Hi Sunny, this is a Qlikview app

[sunny_talwar]

Man you are confusing us with QlikView and Qlik Sense questions

May be on the presentation tab, check 'Suppress Zero Values'.