Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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



Labels (1)
1 Reply
Not applicable
Author

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