Automated top 10 filter

[dmoskow]

I am using Qlik Sense. I am trying to create a filter that automatically can filter for the Top 10 based on an amount field even while I use other filters.

I currently have a filter for unit. I would like to create a filter called "Top 10" that has two options, "Top 10" and "Other". I would like it that when I select "Top 10" it will automatically choose the top highest amount records based on the amount field. It should do this dynamically, so if I select "B" from the Unit filter, I can then use the "Top 10" filter to see the Top 10 employees who spent the most from Unit B. Similarly, if I pick "Other" from the "Top 10 filter" it should be everyone else (excluding the top 10).

Attached is a sample data

Thank you for all your help!

[Kushal_Chawda]

@dmoskow  what you want to filter if you select top 10?

[dmoskow]

I want the top 10 from the Amount field which is a sum.

So my data viz has employee name, the unit, and the sum of their Amount. "Top 10 Filter" would allow me to select just the top 10 records based on the Amount (it would be the same as if I sorted the table from High to low and limited it to the top 10 records)

[Kushal_Chawda · Accepted solution]

see the attached

[dmoskow]

Thank you.

If I may ask, what are the steps done to make that filter. I would like to be able to replicate it in Qlik Sense.

Thank you

[Kushal_Chawda]

@dmoskow  in custom object->Dashboard bundle->variable input

In variable input ->Appearance->variable-> Call the variable and select Button option from "Show as"

Now in Appearance->Values you can create two values as "Top 10" & "Others"

[Kushal_Chawda]

@dmoskow  If it has solve your problem then please accept the solution to close this thread