Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ariel_klien
Valued Contributor

NetWorkDays in the script.

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?

BR

Ariel

Tags (1)
1 Solution

Accepted Solutions

Re: NetWorkDays in the script.

Something like this:

load

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

from ...somewhere...;


talk is cheap, supply exceeds demand
3 Replies

Re: NetWorkDays in the script.

Something like this:

load

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

from ...somewhere...;


talk is cheap, supply exceeds demand
MVP
MVP

Re: NetWorkDays in the script.

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
Valued Contributor

Re: NetWorkDays in the script.

Hi G

Thanks for your answer.

It is working.

Community Browser