This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
SQL SELECT A,B,C, COUNT(D) AS D FROM db.table Group By A,B,C;
View solution in original post
Not sure you try this yet
SQL SELECT A, COUNT(D) FROM db.table;
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.