This content has been marked as final. Show 3 replies
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.