I've defined my QlikView variables in a excel spreadsheet like described here:
Now I would like to define a variable that is calculated via two other variables. Can I simply define the expression like $(varX)*$(varY) in my excel spreadsheet?
this is exactly what I mean, but somehow the calculation doesn't work in my case. Simple example:
So it looks like the calculation doesn't work in QV. It just displays the first variable (varX) in the field (varXY).
What am I doing wrong?