topic Re: group by with num function is not working in QlikView

group by with num function is not working

vikasmahajan — Mon, 16 Jun 2014 04:46:04 GMT

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

Mon, 16 Jun 2014 04:49:39 GMT

you should group by prodname as well.

group by pordcode, ProdName;

tresB — Mon, 16 Jun 2014 04:50:50 GMT

Add ProdName as well in the group by clause like:

....

Resident Sum_Table2

Group By PordCode, ProdName ;

vikasmahajan — Mon, 16 Jun 2014 05:18:14 GMT

Thanks

vikasmahajan — Mon, 16 Jun 2014 05:18:25 GMT

Thanks