Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to display the largest 5 values in a bar graph in Qlik Sense. Can someone please help me through it?
Thanks,
Roshni.
Hi Roshni,
In the options for your bat chart, if you expand the dimension, you should see a button for Limitations that allows you to set 5. The you just need to make sure the sort is configured to sort descending, and you will have your top 5.
Here Show Top Performers are various methods how it could be done with qlikview - dimension limits seems to be not available in sense but the calulated dimension with aggr could be working, something like this:
AGGR(IF(Rank(sum(Sales), 4)<=5, Item), Brand, Item)
- Marcus
Hi,
Top 5:
SUM({<Product = {"=Rank(SUM({<Type = {'AC'}>}Value),4)<=5"}>}Value)
Bottom 5:
SUM({<Product = {"=Rank(-SUM({<Type = {'AC'}>}Value),4)<=5"}>}Value)
HTH,
Hirish