Discussion Board for collaboration on QlikView Scripting.
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.
But I want to do it in the script level.
Go to Solution.
Something like this:
networkdays(date#(THE_DATE,'YYYYMMDD'),monthend(date#(THE_DATE,'YYYYMMDD'))) as NetDays
All the functions you used are supported in script as well. So, Can you please explain what is the real concern you are having?
Thanks for your answer.
It is working.