topic Sum columns in QlikView

Sum columns

Re: Sum columns

Re: Sum columns

mahendragaur — Wed, 15 Nov 2017 11:02:58 GMT

Hello,

I have to sum columns based on parameter mentioned in table. Below is input table -

Merge Column is a parameter on which columns should be summed up and result should be shown in columns.

for ex - Name B. 2 is mentioned in merge column then column1+column2 is added and result should be shown in column1 (same for column 3 and 4). If merge column=1 then leave it as it is.

For merge column=3. 3 consecutive column should be added and sum should be shown in 1st column.

Expected output-

asgardd2 — Wed, 15 Nov 2017 11:49:31 GMT

Hello!

I don't understand, how did you calculate values to Column 2 and Column 3.

For ex. Name = 'B' (Column2 = 7,Column3=5) and Name = 'C'(Column2 = 9, Value from Column3 is empty)

Merge Column

mahendragaur — Wed, 15 Nov 2017 12:01:59 GMT

Hi Anton,

for Name = 'B' (Column1 = Column1+Column2,

Column2 = Column3+Column4,

Column3=Column5+Column6)

because Merge column =2.

Since Column6 is not available that's why column3=column5

for Name = 'C' (Column1 = Column1+Column2+Column3,

Column2 = Column4+Column5+Column6)

because Merge column =3.

Since Column6 is not available that's why column2=Column4+Column5

You can create different table for Output.