Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Top N Filter Pane

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

CustomerPurchase

A

salt

Atea
Bcoffee
Cfruits
Dsalt
Atea
Bcoffee
Bfruits
Csalt
Etea

Regards

1 Solution

Accepted Solutions
kaanerisen
Not applicable

Re: Top N Filter Pane

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)

TopN.png

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

Hope it will help.

3 Replies
kaanerisen
Not applicable

Re: Top N Filter Pane

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)

TopN.png

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

Hope it will help.

Not applicable

Re: Top N Filter Pane

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,

Not applicable

Re: Top N Filter Pane

Thanks a lot kaan