I want description for it?

Kohli — Wed, 14 Feb 2018 06:10:23 GMT

If(RECEIPT_DATE_WORKING < GATE_RCPT_DATE_WORKING,0,

IF(FLOOR(RECEIPT_DATE)<=Floor(GATE_RCPT_DATE_WORKING)+IF(WeekDay(GATE_RCPT_DATE_WORKING)='Fri',3,

IF(WeekDay(GATE_RCPT_DATE_WORKING)='Sat',2,1)),1,0)) AS Score

Re: I want description for it?

petter — Wed, 14 Feb 2018 06:40:53 GMT

If you need an explanation of the expression (I presume that you haven't created the expresssion yourself), it could be like this:

A Score is calculated where:

it will be 0 if the RECEIPT_DATE_WORKING is less than the GATE_RCPT_DATE_WORKING on on a date and time basis.

it will be 0 if the RECEIPT_DATE (not taking time within the date into consideration) is less or equal than the RCPT_DATE_WORKING (no time part considered) with this date pushed forward to the following Monday if the RPCT_DATE_WORKING is a Friday or Saturday.

it will be 1 if the RECEIPT_DATE (not taking time within the date into consideration) is greater than the RCPT_DATE_WORKING (no time part considered) with this date pushed forward to the following Monday if the RPCT_DATE_WORKING is a Friday or Saturday.

topic I want description for it? in QlikView

I want description for it?

Re: I want description for it?