Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
In Qlikview I have a list of articles,the stockvalue by article and the date (DD/MM/YYYY) of last purchase. I want to create a table in which we can see per year of last purchase, all articles and their stockvalue.
Example
Year of purchase
2015 Article X 3.000 euro
2015 Article Y 5.000 euro
2015 Total 8.000 euro
2016 Article A 2.000 euro
2016 Article B 7.000 euro
2016 Total 9.000 euro
....
The example you have provided below is the output you are expecting to see or is this input data?
Hi
This is the output I want to see. If possible year by year with the possibility to expand the year and see the articles involved.
Would you be able to provide the input data to see how the data looks like?