Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
ciphergod
Contributor III
Contributor III

Networkdays not excluding holidays

Hi all,

Facing this issue whereby networkdays isnt excluding holidays in its calculation.

The holiday dates are in a separate excel file i have uploaded, just one column of the dates. I have used this method found here https://community.qlik.com/t5/QlikView-Documents/Find-Net-Working-Days/ta-p/1476739 to concat the dates together. 

The formula i used in creating my master dimension is =Networkdays(Date, Today(), vPublicHolidays) -1 

However, the output of this formula is no different from if i did not include the holidays. 

Any idea what went wrong that resulted in this?

1 Solution

Accepted Solutions
ciphergod
Contributor III
Contributor III
Author

Hi all,

 

managed to resolve the issue and now its working.

initial formula was:

networkdays(Date, Today(), vPublicHolidays)-1

changed to:

networkdays(Date, Today(), $(vPublicHolidays))-1

 

pardon my ignorance but any idea why putting vPublicHolidays within $()  made it work?

View solution in original post

5 Replies
sunny_talwar

Can you share an image to show the output of vPublicHolidays in a KPI object?

ciphergod
Contributor III
Contributor III
Author

Hi,

Cant seem to put it in a KPI object. I created it as a dimension and this is the output i get after putting it in a table.

sunny_talwar

Does this work in KPI? $(vPublicHolidays)

ciphergod
Contributor III
Contributor III
Author

hi, 

apparently it doesnt, this is the error shown.

 

edit: using just vPublicHolidays give this result in KPI 2

ciphergod
Contributor III
Contributor III
Author

Hi all,

 

managed to resolve the issue and now its working.

initial formula was:

networkdays(Date, Today(), vPublicHolidays)-1

changed to:

networkdays(Date, Today(), $(vPublicHolidays))-1

 

pardon my ignorance but any idea why putting vPublicHolidays within $()  made it work?