Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

3 Replies
shraddha_g
Partner - Master III
Partner - Master III

Can you provide sample app?

Not applicable
Author

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
Author

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