Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

using an existing expression in building a new expression

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.

1 Solution

Accepted Solutions
maksim_senin
Partner - Creator III
Partner - Creator III

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

View solution in original post

4 Replies
maksim_senin
Partner - Creator III
Partner - Creator III

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

tresesco
MVP
MVP

You can directly refer them using Column() like:

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

Or, using the label of the expression similarly

amit_saini
Master III
Master III

Yaron,

Please see the attachment.

Thanks,

AS

avinashelite

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]