Networkdays not excluding holidays

[ciphergod]

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?

[sunny_talwar]

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

[ciphergod]

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]

hi, 

apparently it doesnt, this is the error shown.

edit: using just vPublicHolidays give this result in KPI 2

[ciphergod · Accepted solution]

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?