Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
see the attached app.
script:
LOAD Location,
[Part Number],
year(Date) as Date ,
Cost
FROM
(ooxml, embedded labels, table is Sheet1);
Can this help? Let me know what other requirements you are looking for.
see the attached app.
script:
LOAD Location,
[Part Number],
year(Date) as Date ,
Cost
FROM
(ooxml, embedded labels, table is Sheet1);
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!!!
This was very helpful I was able to understand how you did it as well, thanks for the help I really appreciate it!
no problem glad it worked out for you