4 Replies Latest reply: Jul 26, 2017 3:28 PM by Ugonna Okoli RSS

    Count all over due items

    Francisco Ortega

      Hello, I need help getting the total count of records that have a target date prior to today in Qlik Sense.


      count({$<[WORK_ORDER.PERCENTAGE_COMPLETE]-='100',[TARGET_COMPLETION_DATE]= {'<$(date(today(),'DD/MM/YYYY'))'}>} WO_TYPE)


      I have two conditions that I'm checking for, percentage complete is not 100%, indicating the work is not done, and the target date is less than today.


      The code above doesn't work for me.


      Any help is appreciated.


      Thanks in advance!