Discussion Board for collaboration on QlikView Layout & Visualizations.
I tried to add variable in place of expression, lets say for
Exp1=sum() I created a variable ..with vSum=Sum(field),
but the problem is ..the vsum is not according to the dimensions..it is coming as a total for the whole field.?
I need to do this because I want to add triggers using variables.
Go to Solution.
In your load script, define vSum using Set, not Let:
Set vSum = Sum(Field);
Then in your expression, use
If that is still not respecting the dimensions, then its possible that the dimensions are not properly associated with [field] in your data model.
if you writ set vsum ...
and use your variable in the expression it will be computeddinamically according to the object you use
Thanks Guys, it