Hello everyone,
I am new in Qlik and I am struggling with the calculation of the FYs. I've created the Master Calendar as you will see in the table below.
I've created also 2 master items:
YTD = Sum({<
fYear,FMonth,Month,Year,Date={">=$(=YearStart(max(Date),0,4))<$(= addyears(max(Date), 0))"}
>}Cells2G)
PreviousYTD = Sum({<fYear,FMonth,Month,Year,Date={">=$(=YearStart(max(Date),-1,4))<$(= addyears(max(Date), -1))"}>}Cells2G),
but the calculation is not accurate...
What I need as an end result is to represent in a Single Value Chart the percentage resulting from (YTD / PreviuousYTD - 1)*100.
Thank you!
