New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to calculate specific networkdays

Hello All, I am using the following formula to calculate network days between two months and it works for consecutive months

networkdays(min("End Date"),max("End Date"))

HOWEVER

Let's say...If I select January, February and March, the calculation will be OK

If I select only January and March, the calculation WILL include the days from February which I don't want.

Semester 1 2015=129 network days

Q1 2015=64 network days

Jan and Mar 2015=44 days HOWEVER it counts the 20 from Feb

Any ideas on how to solve this? What other formula could I use?

Jose

Tags (2)
6 Replies
Honored Contributor III

Not applicable

Re: How to calculate specific networkdays

 End Date 2/1/2015 1:23:00 AM 2/1/2015 2:07:00 AM 2/1/2015 2:23:00 AM 2/1/2015 8:01:00 AM 6/30/2015 6:58:00 PM
 6/30/2015 7:55:00 PM 6/30/2015 8:01:00 PM 6/30/2015 8:02:00 PM
Valued Contributor III

Re: How to calculate specific networkdays

how are you only getting Jan and March data ?

you should include Feb as part of the holidays parameter

Not applicable

MVP

Re: How to calculate specific networkdays

Please provide proper sample data or file..

I believe that NetWorkDays function is not your friend in this scenario.

You need to work on script to calculated number of days per month similar to NetWorkDays.... But better if you can provide an excel file with proper End Dates along with some sample showing your selection and result you expecting.

Honored Contributor II

Re: How to calculate specific networkdays

As a work around could you create a master calendar and add NetworkDays as a field in it.  You could populate the values in the load or in the data source for your calendar.  So when you select a month you sum the network days of the month selected.

Regards

Andy