Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
You can use Dimension limits with Show largest 5 values .
Remove Show Others and Show Total
.
Regards
Nitin