Discussion board where members can get started with Qlik Sense.
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?
Go to Solution.
managed to resolve the issue and now its working.
initial formula was:
networkdays(Date, Today(), vPublicHolidays)-1
networkdays(Date, Today(), $(vPublicHolidays))-1
pardon my ignorance but any idea why putting vPublicHolidays within $() made it work?
View solution in original post
Can you share an image to show the output of vPublicHolidays in a KPI object?
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.
Does this work in KPI? $(vPublicHolidays)
apparently it doesnt, this is the error shown.
edit: using just vPublicHolidays give this result in KPI 2