Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

ilanbaruch
Contributor III

Working Days

Hi All,

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


advanced thanks

Tags (2)
5 Replies
mtucholski
Contributor

Re: Working Days

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

Help us help you.

ilanbaruch
Contributor III

Re: Working Days

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

MVP
MVP

Re: Working Days

MVP
MVP

Re: Working Days

Try setting system variable in script like:

SET FirstWeekDay=7;

mtucholski
Contributor

Re: Working Days

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

;