Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Slider Help

Joanne:

is this is what  you are trying to do

Utility.jpg

Not applicable

Re: Slider Help

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

MVP & Luminary
MVP & Luminary

Re: Slider Help

Hi,

Please find attached file for solution.

Regards,

Jagan.

Gabriel
Valued Contributor III

Re: Slider Help

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