Discussion board where members can get started with QlikView.
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!
Go to Solution.
Either create a table chart with dimension cdprodukt and expression
or do a resident grouped by load like
sum(aantal) as SumByArticle,
resident lb-182 group by cdprodukt;