Counting number of items with date later than specified period
Dear Qlik Community,
I have requirement to calculate a number of items that were still outstanding at the end of each reporting period.
I have a RECEIVED_DATE for each item, and a COMPLETED_DATE. Items are placed into a month-period based on the RECEIVED_DATE (I have a table which displays RECEIVED_DATE.autoCalendar.YearMonth).
For each RECEIVED_DATE.autoCalendar.YearMonth, I need a count of items where the COMPLETED_DATE was later than this period. I am trying to configure a measure column with set analysis to do this count but just can't seem to get the syntax right. Following many searches on these forums some of the syntax I've tried are: