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: 
gayathridevi24
Contributor III
Contributor III

Group by function

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

Labels (1)
4 Replies
fredericmante
Partner
Partner

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
Creator III
Creator III

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
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
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