Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
GustavoBotelhoTupy
Contributor
Contributor

Savings Calculation - Compare Values ​​from different dates

Hello Everybody!

I'm having some problems comparing prices of diferent years and using filters to show the savings in the current year. 

The Matematic equation is: Saving = (Price Paid - Average Price Last Year)*Quantity of this year

I used this equation for the Average price of last year:

Price2019 Sum({$<Purchase_Date={">=01/01/2019 <=31/12/2019"}>}Purchase_value)/Sum({$<Purchase_Date={">=01/01/2019 <=31/12/2019"}>}Purchase_Quantity)

And this other equation to current year price:

Price2020 = Sum({$<Purchase_Date={">=01/01/2020}>}Purchase_value)/Sum({$<Purchase_Date={">=01/01/2020}>}Purchase_Quantity)

Then 

Saving = (Price2020 - Price2019)*Purchase_Quantity

But, when I apply the filter "Purchase_Date" to keep up with the current saving on the chart or table, an error occurs. 

The image below is without date filter

Saving Calculation - No Date selectedSaving Calculation - No Date selected

 

This other image has a date filter for 2020

Saving Calculation - 2020 Selected DateSaving Calculation - 2020 Selected Date

Could anybody help me?

Labels (1)
0 Replies