topic how to set variable value dynamically in QlikView

how to set variable value dynamically

Thu, 05 Apr 2012 01:23:20 GMT

I am trying to do "what -if " analysis and I have created a variable using it in slider object. I am calling that valiable in chart to calculate the "what if " amount. I want to set the variable value dynamically ie. if i change my selection (like year) it shoud change the percentage amount, but it is not changing dynamicalley.

vPerAmt = sum(amountreceived)/sum(amountcharge)

Thanks for your help.

how to set variable value dynamically

adhudson — Thu, 05 Apr 2012 01:57:34 GMT

Hi,

I have a simple question for you.

If you are using variables in slider control, it should be used in the chart as well to take affect.

Are you using the variable(used in slider control) anywhere in the chart?

Check and get back to me.

Or you can also share your application for my better understanding.

Regards

Hudson

how to set variable value dynamically

CELAMBARASAN — Thu, 05 Apr 2012 04:45:55 GMT

Hi,

Go to variable overview add variable value as

= sum(amountreceived)/sum(amountcharge)

Celambarasan

how to set variable value dynamically

Fri, 06 Apr 2012 02:07:32 GMT

Thanks for your information. Correct I am using this variable in a char. I found the answer to my question.

how to set variable value dynamically

adhudson — Mon, 09 Apr 2012 00:47:49 GMT

Hi,

Can you please mark the correct answer for me?

Thanks

Andrew Hudson