Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kshitijas
New Contributor III

NetworkDays problem!

Hello everyone,


Having NetworkDays with same Start Date and End Date gives Value as 1 i want it as 0,

Tried using if(start date=end date,0,networkdays(Startdate,enddate)) Still Giving output as 1...y is it so??

Thanks&Regards

1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: NetworkDays problem!

Does your start date and end date also have time stamps?

try this instead


= if(FLOOR(NUM(start date))=FLOOR(NUM(end date)),0,networkdays(Startdate,enddate))

3 Replies
vinieme12
Esteemed Contributor II

Re: NetworkDays problem!

Does your start date and end date also have time stamps?

try this instead


= if(FLOOR(NUM(start date))=FLOOR(NUM(end date)),0,networkdays(Startdate,enddate))

kshitijas
New Contributor III

Re: NetworkDays problem!

Hello Vineeth ,

Thankyou it worked .

vinieme12
Esteemed Contributor II

Re: NetworkDays problem!

Happy to help

Cheers

V