Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
divya_anand
Creator II
Creator 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?

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

6 Replies
sunny_talwar

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

View solution in original post

MK_QSL
MVP
MVP

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
Creator II
Creator II
Author

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

divya_anand
Creator II
Creator II
Author

Hi Manish,

in that post my question was on the legend.

Anyways that post had half of my answer there.

Thank you.

sunny_talwar

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

MK_QSL
MVP
MVP

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.