Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Script

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

1 Reply
MVP
MVP

Re: Script

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 ;

Community Browser