Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan
Champion
Champion

group by with num function is not working

Sum_Table2:

LOAD

     PordCode,

     ProdName,

     SIMCode,

     num([Sls Amt],'###0.00') as [Sls Amt],

     num(COGS,'#,##0.00') as COGS,

     num(%COGS,'#,##0.00') as %COGS,

     num([Gr Margin],'#,##0.00') as [Gr Margin],

     num([%Gr Margin],'#,##0.00') as [%Gr Margin]

FROM

[..\Qvds\Item_Margin.qvd]

(qvd);

load

     PordCode,

     ProdName,

    sum( [%Gr Margin])

    //count([%Gr Margin]) as [%Gr Margin]

Resident Sum_Table2

Group By PordCode;

drop table Sum_Table2;

Gives error invalid expression  any body got such issues ?

Vikas

1 Solution

Accepted Solutions
Not applicable

you should group by prodname as well.

group by pordcode, ProdName;

View solution in original post

4 Replies
Not applicable

you should group by prodname as well.

group by pordcode, ProdName;

View solution in original post

tresesco
MVP
MVP

Add ProdName as well in the group by clause like:

....

Resident Sum_Table2

Group By PordCode, ProdName ;

vikasmahajan
Champion
Champion
Author

Thanks

vikasmahajan
Champion
Champion
Author

Thanks