topic Re: Display top 5 values in a Graph in QlikView

Display top 5 values in a Graph

Fri, 22 Jan 2016 21:33:38 GMT

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.

Re: Display top 5 values in a Graph

dominicmander — Sat, 23 Jan 2016 08:24:55 GMT

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.

Re: Display top 5 values in a Graph

marcus_sommer — Sat, 23 Jan 2016 08:32:24 GMT

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

Re: Display top 5 values in a Graph

HirisH_V7 — Sat, 23 Jan 2016 10:21:17 GMT

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