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

[effinty2112 · Accepted solution]

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

[Anonymous]

Use the dimension limits in the chart properties you can set this to show the top 5 and un-tick the checkbox to show others.

[beck_bakytbek]

hi try this:

if(aggr(Rank(Sum(field)),YourDimension) <=5,YourDimension,Null()) and in Tab: Dimension: Settings for Selected Dimension : Check: Suppress when Value is Null

i hope that helps

beck

[Anonymous]

You can use Dimension limits with Show largest 5 values .

Remove Show Others and Show Total

.

Regards

Nitin