topic add more columns with calculation for exist table in QlikView

add more columns with calculation for exist table

yink-hpv — Thu, 01 Feb 2018 22:34:05 GMT

I have a table created named TTT, I am trying to create more field with calculation for this table and create a new table named Table1

My loading script as below, please help me if I have done something wrong

Talbe1:

Load *,

A&B&C as ABC

D AS D_123

RESIDENT TTT;

JOIN (TTT)

LOAD

A&B&C as ABC,

SUM(SALES) AS SALES_A

GROUP BY A;

JOIN (TTT)

LOAD

A&B&C as ABC

SUM(SALES) AS SALES_A_B

GROUP BY A, AND B;

Re: add more columns with calculation for exist table

jerryyang756 — Fri, 02 Feb 2018 06:12:20 GMT

Please provide the Table TTT

Re: add more columns with calculation for exist table

yink-hpv — Wed, 07 Feb 2018 00:06:33 GMT

Table TTT has Field

sales

Re: add more columns with calculation for exist table

jerryyang756 — Fri, 09 Feb 2018 05:52:56 GMT

TTT:

Load * Inline [

A,B,C,D,Sales

10,20,30,40,130

];

Talbe1:

Load *,

A&B&C as ABC,

D AS D_123

RESIDENT TTT;

JOIN (Talbe1)

LOAD

A&B&C as ABC,

SUM(A) AS SALES_A

RESIDENT TTT

GROUP BY A,B,C;

JOIN (Talbe1)

LOAD

A&B&C as ABC,

SUM(A)+Sum(B) AS SALES_A_B

RESIDENT TTT

GROUP BY A,B,C;

DROP Table TTT;

// After running this script I am getting the following output