Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jorn_vango
New Contributor III

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?

Thanks!

1 Solution

Accepted Solutions
dwforest
Valued Contributor

Re: Allow dashboard viewer to set min/max of a measure

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

4 Replies
dwforest
Valued Contributor

Re: Allow dashboard viewer to set min/max of a measure

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

jorn_vango
New Contributor III

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

dwforest
Valued Contributor

Re: Allow dashboard viewer to set min/max of a measure

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

jorn_vango
New Contributor III

Re: Allow dashboard viewer to set min/max of a measure

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