topic Re: Exclude Saturday and Sunday in QlikView

Exclude Saturday and Sunday

chandra63 — Sat, 16 Nov 2024 05:02:43 GMT

Hi All,

I have sample Expression.

if([EMI Amount] <= [RZ\Wav Amount] and date([Installment Due Date]+3)>=[Wav\RZ Date],'NOT OD',
if([EMI Amount] >= [RZ\Wav Amount] and match(Status,'01','02','04','06','10'),'OD',
if([EMI Amount] <= [RZ\Wav Amount] and date([Installment Due Date]+3)<[Wav\RZ Date],'Recovered'))) as OD_Details.

it is working fine. But User want to Exclude weekends .

Instead of 3 in expression we want to show 3 working days.

how i can achieve that.

Can anyone suggest an idea to me?

Thank you for interesting.

Regards.

Chandra

Re: Exclude Saturday and Sunday

hopkinsc — Thu, 06 Dec 2018 10:14:14 GMT

Try using the networkdays function

Networkdays

Re: Exclude Saturday and Sunday

chandra63 — Thu, 06 Dec 2018 10:51:24 GMT

Hi,

how can i take 3 networkdays .

date([Installment Due Date]+3*Networkdays) i tried like this .but it not working

Re: Exclude Saturday and Sunday

hopkinsc — Thu, 06 Dec 2018 10:57:07 GMT

what about

networkdays(date([Installment Due Date]+3))

see if that works

Re: Exclude Saturday and Sunday

chandra63 — Thu, 13 Dec 2018 12:58:22 GMT

Hi,

It is not working fine..

Thanks.

Re: Exclude Saturday and Sunday

chandra63 — Thu, 13 Dec 2018 13:15:37 GMT

Hi,

we have to show installment plus 3 working days .

ex:

installment_Date + 3(installment_dates). which has to exclude weekends