Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to implement group by function in script, but it is coming as invalid expression.
Could you please help me to solve this issue.
Please find the attached source file and qvw file.
Thanks in advance
Thanks and Regards,
Gayathri Devi
hi,
Tri This :
LOAD NAME,
SUM(SALES),
NO
FROM
[C:\Users\BSLKGULDU2\Desktop\qlik\check group by.xlsx]
(ooxml, embedded labels, table is Sheet1) Group by NO,NAME;
Regards
Hi
Group by always work with Resident.
Use something like this:
Table:
LOAD NAME,
SUM(SALES),
NO
FROM
[C:\Users\BSLKGULDU2\Desktop\qlik\check group by.xlsx]
(ooxml, embedded labels, table is Sheet1) ;
FinalTable:
Load
Name,
SUM(SALES),
NO
Resident Table Group by NO;
Drop Table Table
Gayathri, did either of the posts help you with your issue? If so, do not forget to return to the post and use the Accept as Solution button on the post(s) that helped, as this gives the poster credit for the assistance and it also lets other Community Members know what worked.
Also including Help link, which does have some examples toward the bottom that may help too:
Regards,
Brett
Your Group By must list all fields in the LOAD that you are not aggregating. So in your case it would be:
Group By NO, NAME
-Rob