Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

amuratbar
New Contributor III

NetworkDays with Saturday

Hi All,

How can i calculate networkdays between Monday to Saturday? is there any parameters?

Thanks.

Note : NetworkDays function calculates Monday to Friday.

Tags (1)
1 Solution

Accepted Solutions

Re: NetworkDays with Saturday

You will need to use a work around... NetWorkDays is only for Monday to Friday

2 Replies

Re: NetworkDays with Saturday

You will need to use a work around... NetWorkDays is only for Monday to Friday

amuratbar
New Contributor III

Re: NetworkDays with Saturday

Yes, i use awork around as;

If(Match(WeekDay(DATE),'Pzt','Sal','Çar','Per','Cum','Cmt'),'1','0') as [FlagNetWorkDays], //Short EN Days 'Mon','Tue','Wed','Thu','Fri','Sat'

If(Match(WeekDay(DATE),'Pzt','Sal','Çar','Per','Cum','Cmt'),'0','1') as [FlagSunday] //Short EN Days 'Mon','Tue','Wed','Thu','Fri','Sat'

Thank you

Community Browser