The set analysis look like this:
Expression label Actual month: ='Actual (TY)' & chr(10) & date(addmonths(date(max(Inv_date)+1),-1)) & chr(10) & date(addmonths(date(max(Inv_date)),-0)) . Returns: Actual (TY) 01.04.2009 - 30.04.2009
Expression label Accumulated Year:='Actual (TY)' & chr(10) & Date(yearstart ( date(max(Inv_date)), 0, 5 )) & chr(10) & date(max(Inv_date)) . Returns: Actual Year 01.05.2008-30.04.2009
Set analysis for chart expression Month: -sum({$< Month = {*}, Year = {*}, Inv_date = {*} - {"<$(=num(addmonths(date(max(Inv_date)+1),-1)))"} - {">$(=max(Inv_date))"}>} Amount*(SYSVAL_KURS/100))/1000
Set analysis for chart expression Year: -sum({$< Month = {*}, Year = {*}, Inv_date = {*} - {"<$(=num(yearstart ( date(max(Inv_date)), 0, 5 )))"} - {">$(=num(addmonths(date(max(Inv_date)),-0)))"}>} Amount*(SYSVAL_KURS/100))/1000
When I qlik on Mai which is the first month in our new accounting year for 09/10. The expression label returns month 30.04.09 29.05.09 and accumulated year as 01.05.2009-29.05.2009.
I wonder if anyone have accomplished to make a chart for three years turnover with Actual month amount and Accumulated year amount.
Hoping to hear good news/ Anette
