Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Highlighted
renjithpl
Valued Contributor

2018 week number issue

Hi 

I have written a basic script for Week, =Week(today() - 17), which returns 53, however, 2018 has only week 52. 

Any suggestion. 

Regards

Renjith

1 Solution

Accepted Solutions
vvira1316
Valued Contributor II

Re: 2018 week number issue

There were 52 Sundays and 53 Mondays in 2018, Depending on the start day of the week you may get 52 or 53.

you may want to define/use default start day of the week

1 Reply
vvira1316
Valued Contributor II

Re: 2018 week number issue

There were 52 Sundays and 53 Mondays in 2018, Depending on the start day of the week you may get 52 or 53.

you may want to define/use default start day of the week