Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anitamanders
Contributor II
Contributor II

need help with the formula "sum"

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

1 Reply
swuehl
MVP
MVP

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