Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Storing variables outside of QlikView

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

7 Replies
Highlighted
MVP & Luminary
MVP & Luminary

In this way it should work.

- Marcus

Highlighted
MVP
MVP

Highlighted
Not applicable

Hi,

this is exactly what I mean, but somehow the calculation doesn't work in my case. Simple example:

Temp_Variables_xls.PNG Variables_QV.PNG Variableslist_QV.PNG Straight_Table_QV.PNG

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

Highlighted
Not applicable

Just solved it. The problem is the concatenated comment:

qv_variable.PNG

Leading to this:

qv_variable_problem.png

Greetings

Simon

Highlighted
Not applicable

So I just left out the comment to make calculation work:

qv_variable_without_comment.PNG

Any idea how to concatenate the comment variable AND have correct calculation?

Greetings

Simon

Highlighted
Not applicable

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

Highlighted
MVP & Luminary
MVP & Luminary