Count all over due items

[#1]

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!

[Anonymous · Accepted solution]

Try this:

     Count({<[WORK_ORDER.PERCENTAGE_COMPLETE]={"<100"}, TARGET_COMPLETION_DATE={"<$(=today())"}>} WO_TYPE)

[Anonymous]

This shouls work, if the [TARGET_COMPLETION_DATE] has format 'DD/MM/YYYY':

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

[#4]

Thank you! this code worked.

[Anonymous]

Awesome!

You can mark thread as answered/closed.