Display top 5 values in a Graph

[#1]

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.

[dominicmander]

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.

[marcus_sommer]

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

[HirisH_V7]

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