I am trying to find YoY growth using the charts. So I have a formula where I use variable in the DLE and have set the values of dates I want to compare. I get some results from Qlik Sense but they are not accurate. The data set is big and is in a table format with columns for Calendar Date, Bookings, products, customers, country etc.
Looks like I am running into Aggr problem, but I am not able to figure out how to use Aggr function in this case.
(Sum({$<[PRData.Calendar Date]={"<=$(SameDay_Current_Qtr)"}*{">=$(Begin_Current_Qtr)"}>}[PRData.Bookings Amount($)])-
Sum({$<[PRData.Calendar Date]={"<=$(SameDay_PY_Current_Qtr)"}*{">=$(Begin_PY_Current_Qtr)"}>}[PRData.Bookings Amount($)]))
/Sum({$<[PRData.Calendar Date]={"<=$(SameDay_PY_Current_Qtr)"}*{">=$(Begin_PY_Current_Qtr)"}>}[PRData.Bookings Amount($)])
For YoY compare, I am trying to sum the bookings for Q1'20 which is 11/1/19 to 1/31/20 and sum the bookings for Q1'21 which is 11/1/2020 to 1/31/2021, and then use the formula above.