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: 
Not applicable

Slider Help

Hi

I am new to QV and for the life of me cannot work out how to link my slider to the qv table.

I would like the slider to show relative % and the table to reflect which relative percentages to show in the table.

Table looks like below

departmentRelative %
gas50.00
elec30.00

slider will be on relative % 1-100% scale. I have a variable set up which reflects wha has been selected in the slider.

Please can someone help me with the formula for the table and also where to assign it - ie dimension or expression.

Thanks

Jo

4 Replies
Not applicable
Author

Joanne:

is this is what  you are trying to do

Utility.jpg

Not applicable
Author

Hi Jo,

Right click -> New Sheet Object -> Slider/Calendar Object.

You need to assign the field in the General -> Data -> Field -> Relative(Data base column which you want to represent).

You can adjust the scaling in Presentation Tab.

Thanks

Sai Krishna

jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached file for solution.

Regards,

Jagan.

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi Joanne,

You mentioned that you have defined a variable!

Then you want to link it to your chart

What I will do in this case is to right click on the chart > Properies > Expression > Add new expression (click ADD) > then enter Relative * (1+ VARIABLE NAME)

Click OK

Then give the new expression a name LABEL

You will see new column added to the straight table with the label you've given

then right click on the blank space on the page, select Slider > in the General tab > check the radio button for variable and select your variable name (if not showing by default) > down the page set minimum value & maximum value > select the Number tab and specify % > click OK and Apply

Let me know if that helps.

Regards,

Gabriel