topic Re: Slider based on a calculated value? in QlikView

Slider based on a calculated value?

Thu, 20 Jun 2013 02:50:54 GMT

Hi,

I want to make a slider based on a calculated value, it's like:

num(sum(dataA)/sum(dataB),'##.##%')

also another one:

if(sum(dataC)=0 or sum(dataC)<1,0,Num( (sum(dataC)-sum(dataD))/sum(dataC) , '#,##0%'))

Is it possible to do that?

Best Regards

Peter

Re: Slider based on a calculated value?

Gysbert_Wassenaar — Thu, 20 Jun 2013 06:48:01 GMT

Not as far as I know. Selections can be made in fields, not expressions. You can tie the slider to a variable and use the variable in an expression to check if the value in another expression matches the value of the variable.

Re: Slider based on a calculated value?

Thu, 20 Jun 2013 08:16:49 GMT

THANKS! Could you tell me how to set variables?