Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

FilterPane Top 5, Top 10 Data QlikSense Desktop

Hello.

I am using Qlik Sense Desktop, and I have this Pivot table

Inventory      Count         

Honda              15    

Toyota               5

BMW                 6

Mazda               3

Ford                  7

GM                   4

Nissan              19

Mitsubishi          2

Audi                  17

Volkswagen       20

Acura               8

Lexus               10

Kia                    1

Hyundai            26

Is there a possible way use the Filter Pane to have an option that will say Top 5 and Top 10 counts of cars?

Output: Top 5

Inventory      Count  

Hyundai            26

Volkswagen       20

Nissan              19

Audi                  17

Honda              15


and so on with Top 10


Thank you

2 Replies
Not applicable
Author

May I ask why you want to use FilterPane to show the Top? why don't you just use Table, then set the Top as in the image below. Sort by measure descTopDim.png

Uday_Pasupuleti
Partner - Creator III
Partner - Creator III

Hi Roy,

If you want to give the user an option to select Top5 or Top10 then you might need to use qsVariable extension.

http://branch.qlik.com/#!/project/56728f52d1e497241ae697f8

Thanks,