Allow dashboard viewer to set min/max of a measure

[Anonymous]

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?

Thanks!

[dwforest · Accepted solution]

I've used the variable extension on Branch which allows for sliders to do this.

Basically you use a variable in your measure like:

If(Count(DISTINCT [Encounter CSN])>=$(vMin),Count(DISTINCT [Encounter CSN]))

The slider would then change the value of vMin; the visualization should also have the Include null values unchecked

[Anonymous]

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)? 

[dwforest]

There is no default variable name; might try an older version of the extension or comment on git-hub to get it working with September 2017. Might be able to fix yourself as the source is included.

checking in June 2017, it works, but differently.

Create a variable first as the new extention uses a drop down

[Anonymous]

Thanks David.  I created a variable and selected that in the qsVariable dropdown.