Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: FilterPane Top 5, Top 10 Data QlikSense Desktop

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
Contributor II

Re: FilterPane Top 5, Top 10 Data QlikSense Desktop

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,

Community Browser