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.
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.
View solution in original post
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