topic Group by function in QlikView

Group by function

gayathridevi24 — Sat, 16 Nov 2024 01:42:57 GMT

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

Re: Group by function

fredericmante — Thu, 12 Dec 2019 09:48:18 GMT

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

Re: Group by function

Shahzad_Ahsan — Thu, 12 Dec 2019 11:09:23 GMT

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

Re: Group by function

Brett_Bleess — Thu, 19 Dec 2019 20:43:50 GMT

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/ScriptRegularStatements/Load.htm

Regards,
Brett

Re: Group by function

rwunderlich — Thu, 19 Dec 2019 21:51:38 GMT

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