Sum of Multiple Variables

[#1]

Dear All,

Unable to sum two variables. Please assist.

I have tried the following after Creating a  new variable V_tester in the Variables Overview

V_tester = $(Var_1) + $(Var_2)

andl

V_tester = Var_1 + Var_2

This is in Qlikview and not in the script.

Please sugesst how do I add.

With regards

[vinieme12]

Try below

V_tester = $(=Var_1) + $(=Var_2)

or

=rangesum( $(=Var_1) , $(=Var_2))

please also post expression for these two variables if the issue persists

[petter · Accepted solution]

One of the fastest ways of debugging your expressions and variables is by using an INPUT BOX. The input box can show several variables at once and any type of QlikView expression can be written and evaluated directly in an input box.

Create a new input box and add your three variables like this:

Then you can immediately inspect all three variables and modify them to see what it evaluates to.

Example - if you have the two variables Var_1 and Var_2 populated with 456 and 890:

It might seem like your variables don't evaluate to numbers - thus adding them together will not give you a numeric result - possibly and error. Like this:

For me Input Box is an invaluable aid in getting my expressions correct and saving a lot of time while debugging them.

[jagan]

Hi,

What are the values you are getting in the two variables Var_1 + Var_2?   Check it by using Text Objects or by using Input boxes.

If you are getting one of the variable value as Null, then better use RangeSum()

=RangeSum(Var_1, Var_2)

Hope this helps you.

Regards,

Jagan.

[#5]

Dear Petter,

Thanks for the method used... This assists in the overall development perspective a lot.

Thanks also to Jagan and Vineet...