Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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