Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
New to qlik, love the product so far but hit a wall. I know qlik can do it, I use to do this in excel with ease, but just can't figure out how to do this year over year saving comparison.
Basically, I have a unit price from this year and last year, I need calculate the savings opportunity for each element using 2015 unit price with 2016 quantity vs. 2016 price. so for the first one, it will be $49.87 [2015 unit cost] * 272 [2016 qty] - ($4.01 [2016 qty] * 272 [2016 qty]) = savings opportunity.
Please let me know if this make sense.
Ken
I was able to figure it out from the year example I got from this forum. thank you very much
Can you provide sample app?
hi shraddha, please see attached. hopefully this will give you a better idea of what I am trying to achieve.
many thanks. ken
I was able to figure it out from the year example I got from this forum. thank you very much