Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try this:
Count({<[WORK_ORDER.PERCENTAGE_COMPLETE]={"<100"}, TARGET_COMPLETION_DATE={"<$(=today())"}>} WO_TYPE)
Try this:
Count({<[WORK_ORDER.PERCENTAGE_COMPLETE]={"<100"}, TARGET_COMPLETION_DATE={"<$(=today())"}>} WO_TYPE)
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)
Thank you! this code worked.
Awesome!
You can mark thread as answered/closed.