topic Re: substact N working day from a date in QlikView

substact N working day from a date

mohamed_ahid — Mon, 13 Oct 2014 12:40:07 GMT

Hi all,

I'm facing a probleme with date .Let me explain :

i want to get the date of today minus 20 working day (dont count sunday and saturday)

exemple :

for october 13 2014 - 20 = september 16 2014

Thx

Re: substact N working day from a date

anbu1984 — Mon, 13 Oct 2014 12:57:26 GMT

Dt:

Load Date(Dt_Minus_20) Where DayDiff=20;

Load NetWorkDays(Dt-(20+IterNo()),Today()) As DayDiff,Today()-(20+IterNo()) As Dt_Minus_20 While IterNo() < 10 ;

Load

Today() As Dt

AUTOGENERATE(1);

Re: substact N working day from a date

mohamed_ahid — Mon, 13 Oct 2014 13:23:56 GMT

thx but i didn't get your idea .

Re: substact N working day from a date

anbu1984 — Mon, 13 Oct 2014 13:32:36 GMT

Generate a row with today's date

Load

Today() As Dt

AUTOGENERATE(1);

NetworkDays function return number of days between two dates without including weekends. Following statement generate 9 rows from Today()-20( 22-09-2014) to 14-09-2014

Load NetWorkDays(Dt-(20+IterNo()),Today()) As DayDiff,Today()-(20+IterNo()) As Dt_Minus_20 While IterNo() < 10

Following statement picks date exactly 20 days from current day

Load Date(Dt_Minus_20) Where DayDiff=20;

Re: substact N working day from a date

mohamed_ahid — Mon, 13 Oct 2014 13:37:21 GMT

is there a way to do that on designer rather than developer ?

Re: substact N working day from a date

anbu1984 — Mon, 13 Oct 2014 14:15:00 GMT

Test this expr

=Date(If(NetWorkDays(Today()-26,Today()) = 20,Today()-26,If(NetWorkDays(Today()-27,Today()) = 20,Today()-27,If(NetWorkDays(Today()-28,Today()) = 20,Today()-28))))

Re: substact N working day from a date

jonathandienst — Mon, 13 Oct 2014 14:22:07 GMT

=FirstWorkDate(Date#('2013/10/13'), 20)

HTH

Jonathan

Re: substact N working day from a date

mohamed_ahid — Mon, 13 Oct 2014 14:33:31 GMT

Thanx Anbu and Jonathan you were GREAT.