Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

harrywu1
New Contributor III

How to quote the existing expression by its label name?

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!

existing expression.PNG

7 Replies
ChennaiahNallani
Contributor III

Re: How to quote the existing expression by its label name?

you can create variable and use variables where you want

dapostolopoylos
Contributor III

Re: How to quote the existing expression by its label name?

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)

Father/Husband/BI Developer
MVP
MVP

Re: How to quote the existing expression by its label name?

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.

harrywu1
New Contributor III

Re: How to quote the existing expression by its label name?

Hi, That's a great idea!  Could you give me an example?  Thanks!

ChennaiahNallani
Contributor III

Re: How to quote the existing expression by its label name?

Capture.PNG

Lable Name

=vLabel

harrywu1
New Contributor III

Re: How to quote the existing expression by its label name?

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.

MVP
MVP

Re: How to quote the existing expression by its label name?

chart