topic Re: Variable with spaces (in expression) in QlikView

Variable with spaces (in expression)

zagzebski — Sat, 28 Mar 2015 18:12:15 GMT

I have a variable that has the value of a measure depending on the selection of the user. It works but when I use it in my expression (sum) it always gives a value of 0.

The variable vMeasure result is Amount Revenue or Amount Premium.

I use it simply in the expression: sum('$(vMeasure)')

I assume it has something to do with the fact that the translation would be : sum (Amount Revenue) with no brackets rendering it wrong?

Thanks in advance for any assistance!

Steve

Re: Variable with spaces (in expression)

stigchel — Sat, 28 Mar 2015 18:46:17 GMT

If it is the value of a field you are trying to display, try

sum([$(vMeasure)])

Re: Variable with spaces (in expression)

sunny_talwar — Sat, 28 Mar 2015 18:46:37 GMT

Why not try your variable to be like this:

vMeasure = '[' & Measure & ']'

and then use it in your expression as Sum($(vMeasure))

I think this should work.

HTH

Best,

Sunny

Re: Variable with spaces (in expression)

zagzebski — Sat, 28 Mar 2015 19:02:58 GMT

Thanks - Can't believe it was that simple!

Re: Variable with spaces (in expression)

zagzebski — Sat, 28 Mar 2015 19:04:02 GMT

Thanks Sunny - tried that same thing and it didn't like it. The answer was as simple as adding the brackets [] around the measure.

steve

Re: Variable with spaces (in expression)

sunny_talwar — Sat, 28 Mar 2015 19:05:23 GMT

Hahahaha, it did not like it? QlikView can sometime do that to us... But I am glad you got the solution to what you were looking for.

Best,

Sunny