Discussion Board for collaboration related to QlikView App Development.
I have two columns Date_Opened and Date_Closed.
For a certain SLA metric I need to calculate number of cases closed within certain month / total number of open cases at the end of that month (accumulated).
e.g. : for a month of July 2016 I need Cases Closed in July 2016 / All cases with no Date_Closed on 7/31/2016
Thank you for your answer Rupam, but it looks like my approach was incorrect.
Date_Closed field will eventually be populated, so even if it was empty on 7/31, case might be closed on 8/10.
All I have is one point in time table created at the end of the year.
I am assuming some if statement is needed using MonthEnd function.