topic Re: using an existing expression in building a new expression in QlikView

using an existing expression in building a new expression

Thu, 05 Feb 2015 07:09:07 GMT

hi,

i have an income column and an outcome column, and i wand to build a revenue column based on the first two fields (income-outcome).

how can use an existing expression (income and outcome) in the creation of the new expression (revenue)?

thanks.

Yaron.

Re: using an existing expression in building a new expression

maksim_senin — Thu, 05 Feb 2015 07:12:43 GMT

Hi,

There are three ways:

1. You can use the column labels

2. You can use Column(N) function where N is a number of a column

3. You can use variable with $ expansion, e.g, $(vMyExpression1) and $(vMyExpression2) where, say vMyExpression1 = Sum(Income) and vMyExpression2 = Sum(Outcome)

Best regards,

Maxim

Re: using an existing expression in building a new expression

tresB — Thu, 05 Feb 2015 07:12:57 GMT

You can directly refer them using Column() like:

Column(1)+Column(2)...

Or, using the label of the expression similarly

Re: using an existing expression in building a new expression

amit_saini — Thu, 05 Feb 2015 07:17:18 GMT

Yaron,

Please see the attachment.

Thanks,

Re: using an existing expression in building a new expression

avinashelite — Thu, 05 Feb 2015 07:19:49 GMT

Hi Yaron,

You can directly you the first to expression name and the build the 3rd expression but this works only with in the same chart .

Try like this:

[Label of 1st expression ]-[Label of 2nd expression] in your case

[income]-[outcome]