Given a start date, how to display 8 week intervals

[shirleyc40]

I'm trying to duplicate this table in excel, where I have measures based on date intervals. 

In excel, you can refer to other cells to do the math, but I'm not sure how to do this in Qlik

[edwin · Accepted solution]

this is very similar:
Customizing date range filter in Qlik hub (10 days... - Qlik Community - 1783642

[shirleyc40]

Do you know how I can do two of these while loads and concatenate them? I want to mimic the 4 week one in the middle.

I have this right now

[edwin]

Try this

load date(FirstWeek + (iterno()-1)*28) as WeekStart, date(FirstWeek + iterno()*28 -1) as WeekEnd, 'W'&iterno() as WeekNumber while date(FirstWeek + iterno()*28 -1)<=EndOfPeriod;
load date('2/24/2018') as FirstWeek, date('11/30/2018') as EndOfPeriod AutoGenerate (1);

2/24/2018 is a Saturday so your last day  should be 11/30 which is a Friday

[edwin]

this should be clearer

load date(FirstWeek + (iterno()-1)*4*7) as WeekStart, date(FirstWeek + iterno()*4*7 -1) as WeekEnd, 'W'&iterno() as WeekNumber while date(FirstWeek + iterno()*4*7 -1)<=EndOfPeriod;
load date('2/24/2018') as FirstWeek, date('11/30/2018') as EndOfPeriod AutoGenerate (1);