topic Re: Script in QlikView

Script

MK_QSL — Tue, 15 Oct 2013 08:15:04 GMT

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 !!

Re: Script

tresB — Tue, 15 Oct 2013 08:22:48 GMT

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 ;