3 Replies Latest reply: Nov 29, 2016 10:25 PM by ken li RSS

    Year over year savings calculation

      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.