Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Firstworkdate function issue.

Hi Everyone,

When we use firstworkdate() function it excludes Saturdays and Sundays, but I want to include Saturday as my working day, so what should i do? Is there any other function to calculate the same? Or any other method Please help?

Thanks in advance.

-CS

4 Replies
Highlighted
MVP
MVP

Re: Firstworkdate function issue.

There is no standard option to include Saturdays as working days. If you are using a master calendar, then it is easy enough to create a workday flag that is set for Monday - Saturday. Then you can create expressions using this flag - for example NetWorkDays(..) becomes a count/sum of the flag values.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Not applicable

Re: Firstworkdate function issue.

Thank You Jonathan for quick reply. This might help.

Highlighted
Specialist
Specialist

Re: Firstworkdate function issue.

Hi Chiranjeev

Maybe this

=date(FirstWorkDate(today(),v_n_days)

+Div(WEEKDAY(today()-v_n_days-6)+1-(today()-v_n_days)+today(),7))

where v_n_days is no. of days from firstworkdate which is today.

Regards
Pratyush

Highlighted
Not applicable

Re: Firstworkdate function issue.

Thank You Pratyush, It works.