topic Re: Use Value of Expression for another Expression in QlikView

Use Value of Expression for another Expression

Mon, 03 Nov 2014 19:20:37 GMT

Hello,

I have created a column with pretty lengthy definition. I would somehow like to grab the result of that column to use in another column. Is there a way to do this beside making the expression a variable??

Thank You For Help

Re: Use Value of Expression for another Expression

its_anandrjs — Mon, 03 Nov 2014 19:28:22 GMT

Hi,

If have any sample file then provide please, if possible provide any sample file.

Regards

Anand

Re: Use Value of Expression for another Expression

datanibbler — Mon, 03 Nov 2014 20:07:09 GMT

Hi,

what type is the chart which you want to use that expression in?

=> Generally, it is possible to define one expression, give it any specific name and, in the next expression (but only within the same chart/ object), to refer to the result of that expression just by naming it.

Also, you don't have to display all expressions that you have defined. In a table_diagram for instance you can just switch a radiobutton on the "presentation" tab.

HTH

Best regards,

DataNibbler

Re: Use Value of Expression for another Expression

Anonymous — Mon, 03 Nov 2014 23:28:14 GMT

Yes...you can reference the value of the column simply by referencing the label. No need to use the same expression twice.

Example:

Label: Field1

Label: Field2

=Field1 / 2 // This will give you the value of Field1 divided by two

Re: Use Value of Expression for another Expression

maxgro — Mon, 03 Nov 2014 23:33:25 GMT

also with

Column(n)

to reference column n of your chart

Re: Use Value of Expression for another Expression

Anonymous — Tue, 06 Feb 2018 08:59:08 GMT

Are those columns in the same chart/object? Because if they are, you can use an expression in a different expression by referencing the expression's label.
For example: Assuming I have 2 different expressions, represented as two columns, labeled as: Sum and Average, and I want to multiply the two columns in a different expression, as a different column. In that case my new column's expression would be something like: ([Sum] + [Average]).
In conclusion, if you want to use an expression in a different expression, in the same chart, you can reference them by their labels, using [<label name>]. Generally QlikView will suggest you the expression name if you want to use this mechanism

Best regards,
Mihai Iov