Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ilanbaruch
Specialist
Specialist

Working Days

Hi All,

any idea how to set working days / week days Tuesday to Monday, ?


advanced thanks

5 Replies
mtucholski
Creator
Creator

I have no idea what you are intending to do. How about more specific description? Maybe some examples?

Help us help you.

ilanbaruch
Specialist
Specialist
Author

i.e

Week Number 40 in 2018 covers 10/01/208 To 10/07/2018 (Monday to Sunday).

i want to cover Tuesday to Monday 10/02/2018 To 10/08/2018

swuehl
MVP
MVP

tresesco
MVP
MVP

Try setting system variable in script like:

SET FirstWeekDay=7;

mtucholski
Creator
Creator

Hi,

how about this one:

Calendar:

load * Inline [

Date

2018-09-28

2018-09-29

2018-09-30

2018-10-01

2018-10-02

2018-10-03

2018-10-04

2018-10-05

2018-10-06

2018-10-07

2018-10-08

2018-10-09

2018-10-10

];


load

Date,

Week(Date),

Week(Date-1)

Resident Calendar

;