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!