Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Honored Contributor

Re: Summing 2 Expressions

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

3 Replies
Sokkorn
Honored Contributor

Re: Summing 2 Expressions

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
Contributor

Re: Summing 2 Expressions

where are your expressions put?

if they are in the chart, have u tried:

column(1) + column(2)

Not applicable

Re: Summing 2 Expressions

Thanks Sokkorn

Community Browser