Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Go to variable overview add variable value as

     = sum(amountreceived)/sum(amountcharge)

Celambarasan

View solution in original post

4 Replies
adhudson
Creator II
Creator II

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

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Go to variable overview add variable value as

     = sum(amountreceived)/sum(amountcharge)

Celambarasan

Not applicable
Author

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

adhudson
Creator II
Creator II

Hi,

     Can you please mark the correct answer for me?

Thanks

Andrew Hudson