Re: Working Days - Qlik Community

ilanbaruch · ‎2018-10-09

Hi All,

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

advanced thanks

mtucholski · ‎2018-10-09

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

Help us help you.

ilanbaruch · ‎2018-10-09

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 · ‎2018-10-09

Have a look at

tresesco · ‎2018-10-09

Try setting system variable in script like:

SET FirstWeekDay=7;

mtucholski · ‎2018-10-09

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

;