Sort articles by year of purchase

[petermoyaert]

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

....

[sunny_talwar]

The example you have provided below is the output you are expecting to see or is this input data?

[petermoyaert]

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.

[sunny_talwar]

Would you be able to provide the input data to see how the data looks like?