Top N Filter Pane

[#1]

Hello All,

I have a Customer data sheet and i have various charts showing the customer purchases and so on.. I want to have a filter 'Top n' customers so that the user will chose  the number n (5,10,15,20..) and see the visualizations accordingly.  Let say in the below example, I want to see a filter pane of Top 2,3,4 Customers.

Top n Customers
2
3
4

Customer	Purchase
A	salt
A	tea
B	coffee
C	fruits
D	salt
A	tea
B	coffee
B	fruits
C	salt
E	tea

Regards

[kaanerisen · Accepted solution]

Hi Prateek,

You can achive this easily by using qsVariable extension Qlik Branch

1. First you need to define a variable like 'vTopN' and give a default value like 5.
2. Add the extension and give name same as your variable.
3. Add alternative values to variable like 5,10,20,All
4. On chart, go to dimension property,change limitation to 'Fixed Value' and put $(vTopN) in the expression field.

Note : For All option in variable, you should write an expression like count(total customer)

I added a sample app, you can look at the 'Sales Analysis' sheet.

Hope it will help.

[#3]

Hi Prateek,

First create a temporary table with alternate values, and load the table values in the filter pane.

Map / link with the main table.

Regards,

Rajesh R. S,

[#4]

Thanks a lot kaan

[SL2]

Hi Kaanerisen, I have question on your step 3: Add alternative values to variable like 5,10,20,All

Could you please advise more details on how to add alternative values? thanks!