topic Re: Invalid Expression error in QlikView

Invalid Expression error

samir_bihari — Wed, 19 Apr 2017 04:32:19 GMT

Hi Experts ,

I am trying to load data from a table and using group by function but while executing getting invalid expression error. Below is the code snippet :

LOAD [Item SKU],

[Item Status],

Brand,

Month,

Model,

Quarter,

Year,

Division,

Sum([Sales Quantity]) as [Sales Quantity]

FROM

(qvd) Group By Key ;

The flat file contains many fields (Key is one of the field) but i want only the above mentioned field's data to be loaded grouped by Key .

Can anybody help here how to overcome this issue .

prma7799 — Wed, 19 Apr 2017 04:43:12 GMT

Please share some sample data...

tresB — Wed, 19 Apr 2017 05:07:00 GMT

Try like:

T1:

LOAD

Key,

[Item SKU],

[Item Status],

Brand,

Month,

Model,

Quarter,

Year,

Division

FROM

(qvd) ;

Join

LOAD

Key,

Sum([Sales Quantity]) as [Sales Quantity]

FROM

(qvd) Group By Key ;