Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 desc
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,