net working days

[#1]

hi all

i have to Calculate networking days i know that i will be calculated by networkdays ()

but i don't how to consider two days(SAT,SUN)   as weekend

by using weekend function we get only one day as weekend

So how to get two days (SAT,SUN)  as weekend

thanks in advance

[sujeetsingh]

Have a look of this thread

http://community.qlik.com/thread/69515

[MK_QSL]

You can create something like below in script or in chart expression...

IF(WeekDay([Invoice Date])='Sat' or WeekDay([Invoice Date]) = 'Sun','WeekEnd', 'WeekDays')