topic Re: Generate weeks between two dates in QlikView

Generate weeks between two dates

Micki — Mon, 05 Oct 2020 13:27:13 GMT

Hi folks,

I made mistake in my script and don't know where,

so i create a script to generate weeks between two dates

MinMaxDate: LOAD %_KEY, MIN(StartWeek) AS MinDate, MAX(weekstart(Today())) AS MaxDate RESIDENT WI GROUP BY %_KEY JOIN (WI) LOAD %_KEY, iterno()+MinDate as Dim_WI.StartWeek RESIDENT MinMaxDate While iterno()+ MinDate <= MaxDate;

And it's generate only days between, could you please help ?

Re: Generate weeks between two dates

Kushal_Chawda — Mon, 05 Oct 2020 13:39:35 GMT

@Micki how weeks should look like?

Re: Generate weeks between two dates

Micki — Mon, 05 Oct 2020 13:42:09 GMT

Hi @Kushal_Chawda , I am using with weekstart() so format: 05/10/2020 , 12/10/2020 and so on

Re: Generate weeks between two dates

Kushal_Chawda — Mon, 05 Oct 2020 13:45:27 GMT

@Micki try below

MinMaxDate: LOAD %_KEY, MIN(StartWeek) AS MinDate, MAX(weekstart(Today())) AS MaxDate RESIDENT WI GROUP BY %_KEY JOIN (WI) LOAD %_KEY, Weekstart(MinDate,iterno()-1) as Dim_WI.StartWeek RESIDENT MinMaxDate While Weekstart(MinDate,iterno()-1) <= MaxDate;

Re: Generate weeks between two dates

Micki — Mon, 05 Oct 2020 13:50:18 GMT

@Kushal_Chawda Thank you! it's working