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: 
Not applicable

Problems in set analysis when changing accounting year

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



1 Reply
Not applicable
Author

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