topic Re: How to exclude weekends on queries? in QlikView

How to exclude weekends on queries?

Mon, 10 Feb 2014 08:34:04 GMT

Hi,

May I know how will I excempt weekends for my query below? My condition should only count working days..

if([POSTING DATE]-[Date of Transmittal]<=2,'Within','Over') as PaymentSLA,

Thank you

preminqlik — Mon, 10 Feb 2014 08:38:14 GMT

try like this

if(networkingdays([POSTING DATE],[Date if Transmittal])<=2,'Within','Over') as PaymentSLA

Mon, 10 Feb 2014 09:07:55 GMT

Hi,

It didnt work. It all fell to within SLA. As per checking the raw data, there should be some over SLA.

Thank you

tresB — Mon, 10 Feb 2014 09:18:01 GMT

The function is NetWorkDays(). With proper use, it should work. If you can't get it worked, try to share your sample app here.

Alejandro_Hernández — Mon, 10 Feb 2014 09:24:19 GMT

try with

if((NetWorkDays([Date of Transmittal],[POSTING DATE])<=2),'Within','Over') as PaymentSLA