Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Summing 2 Expressions

Hi Everyone,

Simple one for you today.

I've created 2 Expressions (Expression 1, Expression 2)

I want to create a third Expression that adds the 2 expressions.  I've tried [Expression 1] + [Expression 2], but to no avail.

What would you suggest?

Thank you

1 Solution

Accepted Solutions
Sokkorn
Master
Master

Hi Trung,

We have two ways to do this.

1. We can use Column() to sum up two expression. Ex. Column(1)+Column(2)

2. Or sum two expression with label. Let say

     - Your expression 1 have label: MyValue1

     - Your expression 2 have label: MyValue2

We can sum up two expression1 and 2 by [MyValue1] + [MyValue2]

Regards,

Sokkorn

View solution in original post

3 Replies
Sokkorn
Master
Master

Hi Trung,

We have two ways to do this.

1. We can use Column() to sum up two expression. Ex. Column(1)+Column(2)

2. Or sum two expression with label. Let say

     - Your expression 1 have label: MyValue1

     - Your expression 2 have label: MyValue2

We can sum up two expression1 and 2 by [MyValue1] + [MyValue2]

Regards,

Sokkorn

laujerry
Creator
Creator

where are your expressions put?

if they are in the chart, have u tried:

column(1) + column(2)

Not applicable
Author

Thanks Sokkorn