Group by function

[gayathridevi24]

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

[fredericmante]

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

[Shahzad_Ahsan]

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

[Brett_Bleess]

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:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

Regards,
Brett

[rwunderlich]

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