need help with the formula "sum"

[anitamanders]

I am completly new in Qlikview and have no expierence att all with writing scripts.....

I have made some Qlikview tables, but run against a problem with a table for our stock.

We have stock of different  articlecodes, these articlecodes have different lotnumbers.

I want a table with the total stock of an articlecode

I searched in the differtent help files and think I have to use the formula sum stock (=aantal), group by articlecode (=cdprodukt),

but when I use this in my scipt, I get a scripterror.

See enclosed the test file.

Hope someone can help me with this!

Thanks

[swuehl · Accepted solution]

Either create a table chart with dimension cdprodukt and expression

=sum(aantal)

or do a resident grouped by load like

LOAD

sum(aantal) as SumByArticle,

cdprodukt

resident lb-182 group by cdprodukt;

Regards,

Stefan