Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggr on load script

Hello,

I need to group some fields in a table from the load script. I am not sure of the syntaxis so I need some help here. I am connecting directly to the database. Here is an example of what I need:

I have Table1 with fields A,B,C,D and I need to count field D and group by A. What are the steps I need to follow? Please include also the SQL SELECT * FROM db.table line.

Thank you,

Juan.

1 Solution

Accepted Solutions
Sokkorn
Master
Master

Hi Juan,

SQL SELECT A,B,C, COUNT(D) AS D FROM db.table Group By A,B,C;

Regards,

Sokkorn

View solution in original post

3 Replies
Sokkorn
Master
Master

Hi Juan,

Not sure you try this yet

SQL SELECT A, COUNT(D) FROM db.table;

Regards,

Sokkorn

Not applicable
Author

Hello Sokkorn,

I tried it but it isn't retrieving the data as I need it. I need to group repeated fields to reduce lines and memory.

Juan.

Sokkorn
Master
Master

Hi Juan,

SQL SELECT A,B,C, COUNT(D) AS D FROM db.table Group By A,B,C;

Regards,

Sokkorn

View solution in original post