Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Top 10 Count of Category

Hi Team,

Like we do in Bar Charts - sort Descending on Count of Calls & in presentation tab, restrict only top 10 counts with "Max Visible Number".

I want to do the same in Pivot and Straight Chart.

How to achieve this? Pls Suggest!!

3 Replies
Highlighted
Creator III
Creator III

On the sort tab choose sort by expression and enter:




=
count(fieldname)


and choose descending.

In the presentation tab choose your max amount.





Highlighted
Not applicable

Create a Calculated dimension

if(aggr(rank(expression),dimension)<=10,dimension)

If your dimension is product then your calculated dimension would be

if(aggr(rank(sum(val)),product)<=10,product)

Make sure the expression is sorted desc by y value and that you suppress when value is null



Highlighted
Not applicable

Thanks carneyfm.

Its working.