Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

divya_anand
Contributor II

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

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?

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

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

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)


Capture.PNG

6 Replies
MVP
MVP

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

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)


Capture.PNG

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

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?

divya_anand
Contributor II

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

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

divya_anand
Contributor II

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

Hi Manish,

in that post my question was on the legend.

Anyways that post had half of my answer there.

Thank you.

MVP
MVP

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

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.

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.