Discussion Board for collaboration on QlikView Layout & Visualizations.
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!
Go to Solution.
If it is the value of a field you are trying to display, try
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.
Thanks - Can't believe it was that simple!
Thanks Sunny - tried that same thing and it didn't like it. The answer was as simple as adding the brackets  around the measure.
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.