topic Re: Troubleshooting RangeSum variables in QlikView

Troubleshooting RangeSum variables

dena_reavis — Sat, 16 Nov 2024 01:12:59 GMT

I thought I understood RangeSum was able to ignore a value that doesn't calculate, like if adding up field1 + field2 + field3 and one of the fields is null or not numbers.

I am trying to use RangeSum(var1,var2,var3) to add up three variables and it is not working .... I can't figure out why. The var1, var2, and var3 are calculating fine. I can see them when I put them in separate expressions by themselves. When I change from RangeSum to var1 + var2 + var3 it works correctly. Why?

I'm not using any of the powerful parts of RangeSum for accumulation or anything like that. Nothing fancy at all. The variables I have are just large-ish expressions and I need to add some of them together, so instead of repeating the expressions, I use the variables.

I am using QlikView 12.4. Any help or suggestions are appreciated, thank you.

Re: Troubleshooting RangeSum variables

kaushiknsolanki — Sat, 22 Feb 2020 13:33:28 GMT

HI,

Try below expression and it should work according to me.

Rangesum($(var1),$(var2),$(var3))

Re: Troubleshooting RangeSum variables

dena_reavis — Mon, 24 Feb 2020 18:45:00 GMT

I have them with dollar-sign-expansions already. It turns out I was provided several circular references and that was the main cause.

Other minor cause: loading variables from excel may have picked up some non-breaking spaces as characters instead of regular spaces. Some variables were not calculating as $(var1) * $(var2), but removing the spacing it works correctly $(var1)*$(var2). I have never had problems with spaces in the Qlik expression editor but I should know not to trust Excel.

Thank you!