Slider in Qlik sense

[CharanY28]

Hi All,

I want to show Slider in Qlik sense sheet 

I have a existing pivot table in one of the Qlik sense Application
The pivot table has rows [Institution Name], Date
Values has
Lds: Count({<[Fact Type]={'Ld'}>} distinct [L ID])
Spend ($) : Sum([total spend])
Enr Segment : Count({<[Fact Type]={'Intro Ld'}>} distinct [Enrolled L ID])
Rate by segment : Dual(NUM([# Enr Segment]/ [Lds], '#,##0.00%') & ' (' & num([# Enr Segment],'#,##0') & ' /' & num([Lds],'#,##0') & ')',
([# Enr Segment] / [Lds]))

Now my requirement is to show Institution name that are currently spending

solution maybe::

Measure creation - for slider so they can set the spent volume

If spent > 1 show Lds, Enr etc

How to do,
Please help....
Thanks in advance

[diegozecchini]

Hi!
If I understand correctly you want add a slider in Qlik to filter based on spend volume and use that to show data dynamically in your pivot table.

First create a variable for slider
Go to the "Variables" section in your Qlik Sense app (from the left panel, click on the “Variable overview”) and add a new variable "vSpendThreshold"

In "Edit" mode of your sheet, add an object of type "Variable Input".
Configure it as:
Variable: vSpendThreshold
Label: Spend Threshold
Input Type: Slider
Min / Max / Step: based on your Spend data (e.g., Min = 0, Max = 100000, Step = 1000)

Finally modify the Pivot Table to use it
In your pivot table, you now want to filter institutions where Spend > vSpendThreshold.

You can do this by updating your expressions or by using set analysis with the variable. Example:

Modify your measures like this:

Spend:

Sum(IF([total spend] > $(vSpendThreshold), [total spend]))

or try to adapt to measures you want to

[Mouni09]

Thanks for replying,

I have taken vSpentThreshold as 0, in slider Moin as Zero, max as 5, step as 1
When I added Lds measure to pivot every value is giving zero
My measure is like below
Count({< [Fact Type]={'Ld'},[total spend] = {">$(vSpentThreshold)"}>} distinct [L ID])

when you see in below picture , I have values for  Lds  for some Insitution names where Spend > 0

why I am not getting values for Lds?