topic Re: Only top 5 in bar chart, but not top 5 in each dimension value. in QlikView

Only top 5 in bar chart, but not top 5 in each dimension value.

divya_anand — Thu, 06 Apr 2017 11:57:01 GMT

Hi,

I am trying to create a bar chart like the one in the below screenshot. However, I would like to see only the top 5 Names. By top 5 I mean - the names with highest value of count(Name) irrespective of month. In the table, J=5, which means J belongs to Apr,Feb,Jun,Mar & May hence 5.

So, how do I show only top 5 names in the bar chart?

Re: Only top 5 in bar chart, but not top 5 in each dimension value.

sunny_talwar — Thu, 06 Apr 2017 12:02:03 GMT

I think you were using <=10 in your sample... change your second dimension to this

=Aggr(If(Rank(TOTAL count(Name),4)<=5,Name),Name)

Re: Only top 5 in bar chart, but not top 5 in each dimension value.

MK_QSL — Thu, 06 Apr 2017 12:07:14 GMT

Is this similar post?

Show only top 10 legends, keeping the chart as it is

I mean you want to show all Name in all Months but only want to display top 5 names in Legend?

Re: Only top 5 in bar chart, but not top 5 in each dimension value.

divya_anand — Thu, 06 Apr 2017 12:18:08 GMT

That was a very silly mistake. Anyways, Thank you Sunny.

Re: Only top 5 in bar chart, but not top 5 in each dimension value.

divya_anand — Thu, 06 Apr 2017 12:19:20 GMT

Hi Manish,

in that post my question was on the legend.

Anyways that post had half of my answer there.

Thank you.

Re: Only top 5 in bar chart, but not top 5 in each dimension value.

sunny_talwar — Thu, 06 Apr 2017 12:21:13 GMT

So you got what you were looking for? or are you still looking for help? If you got what you wanted, please close the thread by marking correct and helpful responses.

Best,

Sunny

Re: Only top 5 in bar chart, but not top 5 in each dimension value.

MK_QSL — Thu, 06 Apr 2017 13:17:17 GMT

That's what I thought. In your earlier post, you have got the reply which you are looking for in this post (I think).

Anyway, close the thread if you got your answer.