topic Re: NetWorkDays in the script. in QlikView

NetWorkDays in the script.

ariel_klien — Wed, 11 Sep 2013 11:24:36 GMT

Hello all experts.

I have a table with the field THE_DATE format 'YYYYMMDD' but it was save as string.

I want to count network days in the script.

how can I do that?

In the chart after I load the table it is working.

NetWorkDays(date(MakeDate(left(min(THE_DATE),4),right(left(min(THE_DATE),6),2),right(min(THE_DATE),2)),'DD/MM/YYYY'),

MonthEnd(date(MakeDate(left(max(THE_DATE),4),right(left(max(THE_DATE),6),2),right(max(THE_DATE),2)),'DD/MM/YYYY')))

But I want to do it in the script level.

any idea?

Ariel

Gysbert_Wassenaar — Wed, 11 Sep 2013 11:29:33 GMT

Something like this:

load

networkdays(date#(THE_DATE,'YYYYMMDD'),monthend(date#(THE_DATE,'YYYYMMDD'))) as NetDays

from ...somewhere...;

tresB — Wed, 11 Sep 2013 11:29:39 GMT

Hello Ariel,

All the functions you used are supported in script as well. So, Can you please explain what is the real concern you are having?

ariel_klien — Wed, 11 Sep 2013 11:42:05 GMT

Hi G

Thanks for your answer.

It is working.