Storing variables outside of QlikView

[#1]

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

[marcus_sommer]

In this way it should work.

- Marcus

[maxgro · Accepted solution]

like this?

[#4]

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

[#5]

Just solved it. The problem is the concatenated comment:

Leading to this:

Greetings

Simon

[#6]

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

[#7]

Barry Harmsen provided me with the correct answer on qlikfix.com:

Hi Simon,

If you change the // comment for /* and */ comments then it should work.

Kind regards,
Barry

[marcus_sommer]

In addition: Well-commented variables. Be careful!

- Marcus