Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

samir_bihari
New Contributor

Invalid Expression error

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 .

2 Replies
prma7799
Honored Contributor III

Re: Invalid Expression error

Please share some sample data...

MVP
MVP

Re: Invalid Expression error

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 ;

Community Browser