Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I've defined my QlikView variables in a excel spreadsheet like described here:
Storing variables outside of QlikView - The Qlik Fix! The Qlik Fix!
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?
Thanks!
Simon
like this?
In this way it should work.
- Marcus
like this?
Hi,
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?
Greetings
Simon
Just solved it. The problem is the concatenated comment:
Leading to this:
Greetings
Simon
So I just left out the comment to make calculation work:
Any idea how to concatenate the comment variable AND have correct calculation?
Greetings
Simon
Hi Simon,
If you change the // comment for /* and */ comments then it should work.
Kind regards,
Barry
In addition: Well-commented variables. Be careful!
- Marcus