Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
In QlikView, in the same chart, is it possible to quote/use the existing expressions by its label name?
To avoid repeating the lengthy expression statement, to my understanding, user can quote/use the existing expressions by their label name, as the example below, "ANNUAL(FCST)", in other places of the same chart.
But, does it really work? Or, does user have to add [...] (square brackets) for QlikView to recognize that as an expression label name?
Because sometimes I found it didn't work correctly.
Thanks!
you can create variable and use variables where you want
You have to use square brackets around the Expression label but you can use a much more safer method by referencing the epression you want by using the index number of the expression and the Column function.
In your example you can refer the ANNUAL(FCST) expression like this:
Column(3)
You can refer by label in the same object expressions. That is, the expression can't be referred in another object nor in any label expression. Square brackets is required if the label has space(s) in between.
Hi, That's a great idea! Could you give me an example? Thanks!
Lable Name
=vLabel
Hi Tresesco,
I understand, "Square brackets is required if the label has space(s) in between.".
That's also what made me a bit confused about the use of Square Brackets [].
And, what do you mean by "object"? in the same chart? or in the same expression name?
Thanks.
chart