Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to exclude weekends on queries?


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

4 Replies
preminqlik
Valued Contributor II

Re: How to exclude weekends on queries?

try like this

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

Not applicable

Re: How to exclude weekends on queries?

Hi,

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

Thank you

MVP
MVP

Re: How to exclude weekends on queries?

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

Employee
Employee

Re: How to exclude weekends on queries?

try with

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

Community Browser