topic networkdays - variable replacement not working in QlikView

networkdays - variable replacement not working

jarno_loubser — Mon, 12 Sep 2011 13:19:04 GMT

I'm trying to replace the holiday part of the networkdays function with values in a variable as part of the load statement.

My variable's value is: '2002-12-31','2008-01-01'

The following works:

load

...

networkdays (peek(INCIDENT_DATE),INCIDENT_DATE, '2002-12-31','2008-01-01')

resident ....;

The following ignores my holidays:

load

...

networkdays (peek(INCIDENT_DATE),INCIDENT_DATE, $(HoliDays))

resident ....,;

Please help.

SunilChauhan — Mon, 12 Sep 2011 13:53:27 GMT

i believe we can not assign multiple values into single variable,it need to declare seperately

for each holiday one variable

Miguel_Angel_Baeyens — Mon, 12 Sep 2011 14:26:36 GMT

Hi,

Just try instead

NetWorkDays(Peek('INCIDENT_DATE'), INCIDENT_DATE, '$(HoliDays)')

Note that both the field within Peek() and the variable HoliDays are single quoted.

Hope that helps.

BI Consultant

jarno_loubser — Mon, 12 Sep 2011 14:36:35 GMT

Like many problems this was solved by correctly spelling the variable in question. 😞