Script

[MK_QSL]

How to write below SQL code in QlikView Script ?

Select

PARTNO,

MONTH(DATE) as MONTH,

YEAR(DATE) as YEAR,

SUM(QTY),

SUM(SALESAMT),

SUM(COSTAMT)

From SALES

Group By PARTNO, MONTH(DATE), YEAR(DATE)

Thanks in advance !!

[tresesco]

Try something like:

Table1:

Load

PARTNO,

MONTH(DATE) as MONTH,

YEAR(DATE) as YEAR

From  SALES;

Table2:

Load *,

SUM(QTY) as Tot_Qty,

SUM(SALESAMT) as Tot_Sales,

SUM(COSTAMT) as Tot_CstAmt

Resident Table1

Group By PARTNO, MONTH, YEAR ;