Solved: Re: only show top 5 values in a chart - Qlik Community

Report Inappropriate Content · ‎2016-07-21

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

effinty2112 · ‎2016-07-21

Hello,

You could set the dimension limit to 5 and exclude others in the chart properties or replace your dimension with a calculated dimension Like:

Aggr(if(Rank(Count(Field))<6,Dim), where Dim is your original dimension.

good luck

Andrew

View solution in original post

sunny_talwar · ‎2016-07-21

May be like this:

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

narendiran · ‎2016-07-21

Hi,

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

Report Inappropriate Content · ‎2016-07-21

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 · ‎2016-07-21

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 · ‎2016-07-21

Un tick show others

sunny_talwar · ‎2016-07-21

Have you suppressed zero?

Anonymous · ‎2016-07-21

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

Report Inappropriate Content · ‎2016-07-21

Hi Sunny, this is a Qlikview app

sunny_talwar · ‎2016-07-21

Man you are confusing us with QlikView and Qlik Sense questions

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