Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ciphergod
New Contributor II

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?

Tags (2)
1 Solution

Accepted Solutions
ciphergod
New Contributor II

Re: Networkdays not excluding holidays

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

Re: Networkdays not excluding holidays

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

ciphergod
New Contributor II

Re: Networkdays not excluding holidays

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.

Re: Networkdays not excluding holidays

Does this work in KPI? $(vPublicHolidays)

ciphergod
New Contributor II

Re: Networkdays not excluding holidays

hi, 

apparently it doesnt, this is the error shown.

 

edit: using just vPublicHolidays give this result in KPI 2

ciphergod
New Contributor II

Re: Networkdays not excluding holidays

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