Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Count all over due items

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!

1 Solution

Accepted Solutions
okolyug16
Contributor II

Re: Count all over due items

Try this:

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

4 Replies
okolyug16
Contributor II

Re: Count all over due items

Try this:

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

mov
Esteemed Contributor III

Re: Count all over due items

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)

Not applicable

Re: Count all over due items

Thank you! this code worked.

okolyug16
Contributor II

Re: Count all over due items

Awesome!

You can mark thread as answered/closed.

Community Browser