topic Problem with Group By in QlikView

Problem with Group By

Tue, 31 Aug 2010 05:16:00 GMT

Hi,

I am trying to load records from resident table but I am having problem, please see below:

SALES:
LOAD
CUSTNO,
VOL_ACTUAL,
ITEMNO
FROM (ooxml, embedded labels, table is Sheet3);

COMPARE:
LOAD
CUSTNO,
SUM (VOL_ACTUAL) AS VOL_ACTUAL
RESIDENT
SALES
GROUP BY
CUSTNO;

DROP TABLE SALES;

The above works fine, but when i include the ITEMNO, in says that there is an invalid expression:

SALES:
LOAD
CUSTNO,
VOL_ACTUAL,
ITEMNO
FROM (ooxml, embedded labels, table is Sheet3);

COMPARE:
LOAD
CUSTNO,
SUM (VOL_ACTUAL) AS VOL_ACTUAL,
ITEMNO
RESIDENT
SALES
GROUP BY
CUSTNO;

DROP TABLE SALES;

How can i include the ITEMNO field in the LOAD? Thanks in advance.

Miguel_Angel_Baeyens — Tue, 31 Aug 2010 06:05:28 GMT

Hello,

As you are using group by in your load statement, you should include field ITEMNO in group by.

Regards

Tue, 31 Aug 2010 06:09:06 GMT

Dear try this one .......

COMPARE:
LOAD
CUSTNO,
ITEMNO,

SUM (VOL_ACTUAL) AS VOL_ACTUAL

RESIDENT
SALES
GROUP BY
CUSTNO,ITEMNO;

Bhushan N