Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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
Highlighted
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

Highlighted
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

Highlighted
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.

Highlighted
Employee
Employee

Re: How to exclude weekends on queries?

try with

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