topic Re: Date Variables (business days) in QlikView

Date Variables (business days)

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Is it possible to to set variables showing:

1) Today() minus one business day

2) Today() minus two business days

3) Today() minus three business days

Thanks,

Daniel

Re: Date Variables (business days)

vinieme12 — Mon, 28 Nov 2016 16:17:01 GMT

Try

=Firstworkdate(DATE#('12/03/2016','MM/DD/YYYY'),1)

This will minus one day to your date and move to the next business day , adding 1 day to Saturdays date and moving to Friday 2 Dec that is previous business day

=LastWorkDate(DATE#('12/03/2016','MM/DD/YYYY'),1)

This will add one day to your date and move to the next business day , adding 1 day to Saturdays date and moving to Monday 5th Dec that is next business day

Re: Date Variables (business days)

danielnevitt — Mon, 28 Nov 2016 16:27:19 GMT

Thanks for your help

Re: Date Variables (business days)

danielnevitt — Mon, 28 Nov 2016 17:00:16 GMT

Hi Vineeth,

Is it possible to use the above in an expression?

I tried the following, however I received an error:

=Sum({<DTLS_PAYMENT_RECEIPT_IND={'R'},ReportDate={FirstWorkDate(DATE#(today(),'DD/MM/YYYY'),1)}>}DTLS_AMOUNT)

Regards,

Daniel

Re: Date Variables (business days)

vinieme12 — Mon, 28 Nov 2016 20:09:44 GMT

Try as below

=Sum({<DTLS_PAYMENT_RECEIPT_IND={'R'}

,ReportDate={"$(=DATE#(FirstWorkDate(today(),1),'DD/MM/YYYY')"}>}DTLS_AMOUNT)

Re: Date Variables (business days)

danielnevitt — Tue, 29 Nov 2016 09:36:56 GMT

Thanks for the response Vineeth.

Unfortunately that expression does not work. It would be much appreciated if you could investigate what the issue might be.

Thanks,

Daniel

Re: Date Variables (business days)

vinieme12 — Tue, 29 Nov 2016 12:03:07 GMT

Try evaluating

=Sum({<DTLS_PAYMENT_RECEIPT_IND={'R'}

,ReportDate={"$(=DATE(FirstWorkDate(today(),1),'DD/MM/YYYY'))"}>}DTLS_AMOUNT)