topic Number days worked by month in QlikView

Number days worked by month

Thu, 24 Nov 2011 16:02:17 GMT

Hello,

I need to get the number of days by month, but I must substract the saturdays and sundays of this number.

Example for November : I must get 22 days.

I don't know how I can do.

thanks for your help.

Thu, 24 Nov 2011 16:18:34 GMT

You could do something like this...

Weekday(Date) as WeekDay

Count(Weekday)

swuehl — Thu, 24 Nov 2011 16:20:03 GMT

Do you have a calendar with Date, Month, Year etc.?

Then create a table chart with dimension Month (or YearMonth), and as expression use:

=networkdays(monthstart(Date),monthend(Date))

If you use a Month or YearMonth of date type, you could also use these as field in the above expression.

Hope this helps,

Stefan

Fri, 25 Nov 2011 13:25:34 GMT

no, I have nothing.

I'm in the script, and I need to create 1 variable by month.

var_01_2011 = 20

var_02_2011 = 18

var_03_2011 = xx

var_04_2011 = xx

...

These variables will be used in a mathematics calculs.

Fri, 25 Nov 2011 13:38:24 GMT

Hello Prophete.

Is something like this:

=COUNT(if(Num(WeekDay(DATE_FIELD)) < 5, DATE_FIELD))

Good Luck

Bruno Oliveira

Fri, 25 Nov 2011 14:23:37 GMT

Thanks you.

My problem is solved with the functions :

set X = networkdays(monthstart(Y) , monthend(Y));