Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
this is very similar:
Customizing date range filter in Qlik hub (10 days... - Qlik Community - 1783642
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
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
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);