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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
JJ2
Contributor
Contributor

YoY calculation not correct in Qlik Sense

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.

 

 

Labels (1)
0 Replies