Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If it is the value of a field you are trying to display, try
sum([$(vMeasure)])
If it is the value of a field you are trying to display, try
sum([$(vMeasure)])
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
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.
steve
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