Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
deepti_singh
Creator II
Creator II

Slider not working in Qlik Sense

Hi,

I have a requirement where I need to use a Slider. The Slider I used is the one published in the Qlik Branch called "Sense Range Slider".

The requirement is that the Slider is supposed to have the minimum salary and the maximum salary as its ranges. And when the user moves the slider either left or right and changes the ranges, the table below it (with the columns Employees and salary) should display ONLY those Employees that have salary in the range selected. Dimension being Employee and expression is sum(salary).

For example, if we change the slider range between 50,000  to 10,000, ONLY those Employees with that salary range should come in the table below. I hard coded one of the ranges to see if that made any difference and it did.

1. In the table, I selected the dimension Employee.

2. From the Limitation, selected "Exact Value" and changed it to >=50000.

3. Wen I apply the changes, I saw that the table has been filtered to ONLY those employees with salaries in more than 50000.

Now all I want is to limit it by the selections that the user makes in the slider.

Thanks.

Regards,

Deepti Singh

1 Solution

Accepted Solutions
deepti_singh
Creator II
Creator II
Author

Hi Andy,

I found a way to get the slider working.

1. First I defined the minimum and maximum salary in the script as vLower and vUpper respectively.

2. Then I defined the ranges in the slider

     (In the "Variable for Lower Values", I wrote vLower and in the "Variable  for Upper Value" vUpper) and in the "Lower Value" the minimum salary and "Upper Value" the maximum salary.

3. Then I created a table with dimension Employee and in the measure I wrote the following set analysis

     if (sum(salary)>= vLower and sum(salary)<= vUpper, sum(salary))

4. Now when I move the Slider to define different salary ranges, I can see that the table limits the employees with that salary range.

Nevertheless thanks for your help.

View solution in original post

4 Replies
ogster1974
Partner - Master II
Partner - Master II

‌You should be storing the values set in your slider in 2 separate variables for use in your charts.

As an intermediary step to troubleshoot your issue

1. SET vMInSalary=10000

2. SET vMaxSalary=50000

In your data script then

3. In your limitation set your exact value >=vMInSalary

IF your table displays corrEctly then move on to wiring your variable into your slider extension and testing the value changing in the front end.  If that extension is not working another one you can use is called qsvaraible

Hope this helps you investigate your issue further

Regards

Andy

deepti_singh
Creator II
Creator II
Author

Hi Andy,

I found a way to get the slider working.

1. First I defined the minimum and maximum salary in the script as vLower and vUpper respectively.

2. Then I defined the ranges in the slider

     (In the "Variable for Lower Values", I wrote vLower and in the "Variable  for Upper Value" vUpper) and in the "Lower Value" the minimum salary and "Upper Value" the maximum salary.

3. Then I created a table with dimension Employee and in the measure I wrote the following set analysis

     if (sum(salary)>= vLower and sum(salary)<= vUpper, sum(salary))

4. Now when I move the Slider to define different salary ranges, I can see that the table limits the employees with that salary range.

Nevertheless thanks for your help.

ogster1974
Partner - Master II
Partner - Master II

Glad you got it working.

Not applicable

Hi,

How did you get it to work? I am trying to do the same. I have defined the vLower and vUpper values in the script. After that I am stuck. Would appreciate your help?

Thanks,

S.