topic Re: Network Days in QlikView

Network Days

varunreddy — Tue, 06 Oct 2015 18:52:39 GMT

Hi Guys,

Can anyone correct the syntax?

networkdays(date#([As of Date],'MM-DD-YYYY'), date#([Creation Date],'MM-DD-YYYY'))

Thanks in advance!

Regards,

Varun

Re: Network Days

MK_QSL — Tue, 06 Oct 2015 18:54:21 GMT

Are you getting syntax error?

Re: Network Days

varunreddy — Tue, 06 Oct 2015 18:55:26 GMT

I am not getting any output.

Re: Network Days

MK_QSL — Tue, 06 Oct 2015 18:57:08 GMT

how you are using it? Provide sample script..

Re: Network Days

varunreddy — Tue, 06 Oct 2015 18:58:17 GMT

I actually want to get number of business days between [As of Date] and [Creation Date]

Re: Network Days

Clever_Anjos — Tue, 06 Oct 2015 18:59:40 GMT

Would you mind posting a sample of your app?

Re: Network Days

Digvijay_Singh — Tue, 06 Oct 2015 18:59:47 GMT

If your dates are in 'MM-DD-YYYY' then format is appearing correct. If dates are not in the used format then you need to use - date(date#([As of Date],'<input date format'),'MM-DD-YYYY')

Re: Network Days

maxgro — Tue, 06 Oct 2015 19:00:29 GMT

if you have text fields as in

=networkdays(date#('01-01-2015','MM-DD-YYYY'), date#('03-01-2015','MM-DD-YYYY'))

your expression should worh

if you have date fields

networkdays([As of Date], [Creation Date])

Re: Network Days

MK_QSL — Tue, 06 Oct 2015 19:00:49 GMT

You will get it... But before that we need some input from you... Can you please provide the script which you are using?

Re: Network Days

varunreddy — Tue, 06 Oct 2015 19:13:36 GMT

Hi Manish,

I don't have access to send you the application

Thanks & Regards,

Varun

Re: Network Days

varunreddy — Tue, 06 Oct 2015 19:18:53 GMT

Hi,

It is giving me 0 and 1 as output for above mentioned expressions.

Thank you for the time!

Regards,

Varun

Re: Network Days

MK_QSL — Tue, 06 Oct 2015 19:20:22 GMT

you can obviously create dummy application! Without this you will get only dummy answers and may be no answer at all.