topic Re: Summing 2 Expressions in QlikView

Summing 2 Expressions

Tue, 16 Jul 2013 01:25:14 GMT

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

Sokkorn — Tue, 16 Jul 2013 01:32:09 GMT

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 — Tue, 16 Jul 2013 01:32:36 GMT

where are your expressions put?

if they are in the chart, have u tried:

column(1) + column(2)

Tue, 16 Jul 2013 01:39:34 GMT

Thanks Sokkorn