topic Re: Use a variable from an input box in a calculation to set another variable in QlikView

Use a variable from an input box in a calculation to set another variable

Fri, 18 Sep 2015 13:07:11 GMT

Hello,

I have a situation where I need users to enter two values in an input box and then I need those numbers to be multiplied and stored in another variable to be used in a chart. I have tried both document triggers, actions in a text box, and assigning the expression to the variable with no luck. See below for details.

The user chooses the two values above (vCommAmt (15) and vCommPct (40)) from the drop down lists in input boxes.

The last part (=$600) is a text box with an expression of = $(vCommAmt)*$(vCommPct).

What I'd rather do is set a variable called vVarComm = $(vCommAmt)*$(vCommPct) and then use that variable in a chart. I have tried setting the variable in the script and setting document triggers 'On Input' and 'On Change' for the above variables but I either get nothing or an error.

Please advise.

Re: Use a variable from an input box in a calculation to set another variable

stigchel — Fri, 18 Sep 2015 13:20:16 GMT

Simply define a new variable with an expression as contents like this, don't forget the =

The result

Also example attached

Re: Use a variable from an input box in a calculation to set another variable

Fri, 18 Sep 2015 13:46:13 GMT

I see what I was doing wrong...

I was defining the variable as = $(vCommAmt)*$(vCommPct) instead of =vCommAmt*vCommPct.

It's working now, thank you!!