Discussion Board for collaboration related to Qlik Education.
I have a data set that contains begin and termination dates I want to sum the column seatcount within.
This is some representative data:
BeginDate TermDate SeatCount
What I have then is a pivot table with a single dimension MonthEnd(BeginDate). The expression i want is based on the following:
sum(if(TermDate<=BeginDate, 0, SeatCount)).DateDate
What I want is the accumulated seatcount minus the seatcount that is terminated. My thought is I should be getting a number that is increasing by date, but that is not happening. Is this a recursion issue?