Qlik Community

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

All Months.JPG

Q1 2015=64 network days

Q1.JPG

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

Jan & Mar.JPG

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

Thanks in advance!

Jose

Tags (2)
6 Replies
sasiparupudi1
Honored Contributor III

Re: How to calculate specific networkdays

Please post sample data

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
ramoncova06
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

Re: How to calculate specific networkdays

any ideas please? kunalbhattacharjee91MRKachhiaIMP

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.

ogster1974
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

Community Browser