topic Re: Total Cost by Year in QlikView

Total Cost by Year

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Total Cost by Year

vishsaggi — Tue, 26 Jul 2016 16:53:03 GMT

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

Re: Total Cost by Year

Anonymous — Tue, 26 Jul 2016 17:50:30 GMT

see the attached app.

script:

LOAD Location,

[Part Number],

year(Date) as Date ,

Cost

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Total Cost by Year

Tue, 26 Jul 2016 18:48:42 GMT

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!!!

Re: Total Cost by Year

Tue, 26 Jul 2016 18:51:07 GMT

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

Re: Total Cost by Year

Anonymous — Tue, 26 Jul 2016 19:35:51 GMT

no problem glad it worked out for you