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

    Year over year savings calculation

    ken li

      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.

       

      123.jpg

       

      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