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.
This sum function works well in a chart but I would like to copy this to the LOAD script but that doesn't work.
Sum(Total<OPA_OPDRNR>Afgenomen?) AS SomAfgenomen, // The ? is part of the field name
How do I calculate the total sum per OPA_OPDRNR in de LOAD statement?
Thanx for any help.
Michel van de Vosse
The brackets must be use by any special char but without it will also work. I Think you need:
Sum(Afgenomen?) as SumAfgenomen
GROUP BY OPA_OPDRNR;
This table is automatically associated per OPA_OPDRNR as Key. Otherwise you could this data also insert per mapping to the maintable.
View solution in original post
Try something like:
Sum(Afgenomen?) as SomAfgenomen
From <> Group By OPA_OPDRNR;
Sum([Afgenomen?]) AS SomAfgenomen
It's not that I want to Group my result records, because that is what I get with a Group By,
I would like the sum of Afgenomen? for the different OPA_OPDRNR in each row.
Afgenomen? OPA_OPDRNR SUM WRONG SUM
1 A 3 6
1 B 2 6
1 C 1 6
Hi Michel, i am not sure about your expersion
I will write syntax
from table group by field.....
GROUP BY Afgenomen?, OPA_OPDRNR;
Adding the  wil tell Qlickview that there is a space in the field name right? But that's not the problem here. See my answer to Tresesco for additional info on what results I am looking for.
See also attatched xls with some test data.
Use group by and get the sum that you want for each OPA_OPDRNR.
group by OPA_OPDRNR;
And then join this with your main table, you will have the sum field as another field to your main table.
Thanx, Now it works, I have done it like this:
SUM(Afgenomen) AS SomAfgenomen
Group By OPA_OPDRNR;
I have repeated this for another field and then with a resident load on the main table I calculated onwards with the two joined fields.