Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
ivandrago
Contributor II

Week No but for Monday Start

Hi,

I have the attached Document which has a calendar table. What I am after is the Week No which starts from Monday and ends in Sunday.

So if you look at the attached spreadsheet (WeekNo_Monday_Start) this is the Week No's I want against the Date range (01/08/2017 to 01/11/2017).

So if we are in a new month and the the first day lets say is Sunday then I would want it to show as Week No 1, but the next date would be on a Monday so I would want the Week No to be  2 for all the dates till that week coming Sunday.

I currently have a "Week No" field and I tried to do the logic on the field called "New Week No" but struggling to do this.

Thanks

1 Solution

Accepted Solutions

Re: Week No but for Monday Start

Henric Cronstrom hic has some excellent blogs on Calendars & Week Nos

Redefining the Week Start

Redefining the Week Numbers

1 Reply

Re: Week No but for Monday Start

Henric Cronstrom hic has some excellent blogs on Calendars & Week Nos

Redefining the Week Start

Redefining the Week Numbers