Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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.

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

1 Solution

Accepted Solutions
Not applicable

Re: Year over year savings calculation

I was able to figure it out from the year example I got from this forum. thank you very much

3 Replies
shraddha_g
Honored Contributor III

Re: Year over year savings calculation

Can you provide sample app?

Not applicable

Re: Year over year savings calculation

hi shraddha, please see attached. hopefully this will give you a better idea of what I am trying to achieve.

many thanks. ken

Not applicable

Re: Year over year savings calculation

I was able to figure it out from the year example I got from this forum. thank you very much