Total Cost by Year

[#1]

Hello All,

I am very new to QlikView and was wondering a simple way to do a few things. I need to find out how to find total cost by year , difference in cost by year and the percentage of difference by year. Attached is the Excel file I am working with and also my QlikView document. Can anyone help with this? Thanks!

[vishsaggi]

Can this help? Let me know what other requirements you are looking for.

[Anonymous · Accepted solution]

see the attached app.

script:

LOAD Location,

     [Part Number],

     year(Date) as Date ,

     Cost

FROM

(ooxml, embedded labels, table is Sheet1);

[#4]

vishsaggi‌ I think this is really close, I think I was able to figure it out with some help with the example below! Thanks for your help and time!!!

[#5]

This was very helpful I was able to understand how you did it as well, thanks for the help I really appreciate it!

[Anonymous]

no problem glad it worked out for you