Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
RichardLee
Creator
Creator

Targeted Variables

on my Dash I have a slider which increases all values but I would like to have targeted changes too.

RichardLee_0-1668172941354.png

 

I would like to add a slider for each product group. How would I do this?

Labels (4)
1 Solution

Accepted Solutions
QFabian
MVP
MVP

Hi @RichardLee , maybe this is an option?, you have to create your variables and sliders first

SUM(Value) * 1 + (
if(Group = 'Adv-EI', $(vSilderAdvEI),
if(Group = 'Adv.-EW', $(vSilderAdvEW),
if(Group = 'Adv-Other', $(vSilderAdvOther),
if(Group = 'EI', $(vSilderEI),
if(Group = 'EW', $(vSilderEW),
if(Group = 'Other', $(vSilderOther)
))))))
)

QFabian

View solution in original post

2 Replies
rubenmarin1

Hi, you can create a variable for each product group and add a slider for each variable, then use the variable in the expressions to see the impact on your data while you move the sliders.

QFabian
MVP
MVP

Hi @RichardLee , maybe this is an option?, you have to create your variables and sliders first

SUM(Value) * 1 + (
if(Group = 'Adv-EI', $(vSilderAdvEI),
if(Group = 'Adv.-EW', $(vSilderAdvEW),
if(Group = 'Adv-Other', $(vSilderAdvOther),
if(Group = 'EI', $(vSilderEI),
if(Group = 'EW', $(vSilderEW),
if(Group = 'Other', $(vSilderOther)
))))))
)

QFabian