Allow dashboard viewer to set min/max of a measure
Is it possible in Qlik Sense to allow the viewer of a dashboard to determine min/max values?
For example, I have a table that shows the sales people, their sales total 6 months ago, their sales total today and the % increase from 6 months ago to today.
In the table, the dimension (salesperson) is set to show "top 5" as calculated on the % increase measure. However, sales people that barely started 7-8 months ago have a giant increase (as their sales 6 months ago were very low), so they always show as part of the top 5, usually with a 100%+ increase.
The executives looking at the dashboard would like to limit the sales people in this table. For example, one exec wants to see only sales people that had a minimum of $100K 6 months ago; another wants the bar to be $200K, etc...
Is there a way to allow the execs to select the minimum threshold for a sales person to be considered for the top 5 table?
Re: Allow dashboard viewer to set min/max of a measure
Thanks David. I installed the qsVariable extension and added the slider. It seems there is a bug however with the extension when used with the September 2017 (Patch 1) version of Qlik Sense server: the extension has nowhere to enter the name of the variable, so not sure how to call it in the expression editor.
Does someone know what the default variable name is (when the slider is used)?