Weekdays.

Anonymous — Thu, 23 Dec 2010 13:52:07 GMT

Hello .. I am using this formula that brings me the result of working days in the month. The exclusion of holidays, I'm using a field "DATA_FERIADO_LOCAL" from my table where are the dates of the holidays. The problem is that for a month if more than one holiday, she can not calculate. I had to put the function "MAX"to just bring in a holiday period prescribed. This is wrong. I need my formula that makes the exclusion of all holidays in the month.

networkdays(MonthStart(AddMonths(today())),MonthsEnd(1,Today()),MAX(DATA_FERIADO_LOCAL)))

Weekdays.

pover — Fri, 24 Dec 2010 04:34:31 GMT

You should put a list of holiday dates, so try

=(networkdays(MonthStart(AddMonths(today())),MonthsEnd(1,Today()),$(=chr(39) & concat(DATA_FERIADO_LOCAL,chr(39)&','&chr(39))&chr(39)))))

or just

=(networkdays(MonthStart(AddMonths(today())),MonthsEnd(1,Today()),$(=concat(DATA_FERIADO_LOCAL,','))))

It might be better to save (=chr(39) & concat(DATA_FERIADO_LOCAL,chr(39)&','&chr(39))&chr(39)) as a variable that you dollar-sign expand in the expression.

Regards.

topic Weekdays. in QlikView

Weekdays.

Weekdays.