Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

how to set variable value dynamically

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.

Tags (3)
1 Solution

Accepted Solutions

how to set variable value dynamically

Hi,

     Go to variable overview add variable value as

     = sum(amountreceived)/sum(amountcharge)

Celambarasan

4 Replies
Highlighted
adhudson
Contributor II

how to set variable value dynamically

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

Hi,

     Go to variable overview add variable value as

     = sum(amountreceived)/sum(amountcharge)

Celambarasan

Not applicable

how to set variable value dynamically

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

adhudson
Contributor II

how to set variable value dynamically

Hi,

     Can you please mark the correct answer for me?

Thanks

Andrew Hudson