topic Re: Reference expression label on another expression in QlikView

Reference expression label on another expression

nkosinde13 — Wed, 25 Nov 2020 16:16:04 GMT

Hi, I have two expressions that I created on a straight table and named them Actual and Core Product. So now for my 3rd expression (TA%) I want use just the label names i.e. = [Actual] / [Core Product] but I'm getting an error. I've attached a screenshot showing the error.

Is there any setting that maybe I need to do? Thanks

Re: Reference expression label on another expression

dapostolopoylos — Wed, 11 Jul 2018 07:53:26 GMT

Sometimes the expression editor returns errors but the expression works as it should.

Have you tried to evaluate the expression, what do you see in your chart?

You can try a workaround which is much safer. If the Actual expression is the first expression in your chart and the Core Product the second then you can define the TA% expression like this:

Column(1)/Column(2)

Re: Reference expression label on another expression

nkosinde13 — Tue, 24 Jul 2018 09:51:57 GMT

Hi Dimitrios, yes thank you very much. Your solution works perfectly.

Re: Reference expression label on another expression

raviityou — Tue, 24 Jul 2018 09:55:51 GMT

you can use `Expression Name`/ `Expression Name` or Column(1)/Column(2) both will work but prefer to use expression.