Problems in set analysis when changing accounting year

Fri, 22 May 2009 21:49:14 GMT

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

Problems in set analysis when changing accounting year

Sat, 23 May 2009 00:30:18 GMT

Please attach your report .qvw file so people can work on it.

topic Problems in set analysis when changing accounting year in QlikView

Problems in set analysis when changing accounting year

Problems in set analysis when changing accounting year