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.