Using AutoGenerate Function correctly

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I want to create a table that will have one field that lists all dates between my oldest date and my most recent date (Field: Created At is the date field). What I have below does not work. The last table I create (Tempcalendar) only shows one date instead of all dates between MinDate and MaxDate. Thanks.

GetDateRange:
Load
date(Min([Created At])) as MinDate,
date(Max([Created At])) as MaxDate
Resident MARKETO;

Let vMinDate=Peek('MinDate',0,'GetDateRange');
Let vMaxDate=Peek('MaxDate',0,'GetDateRange');

TempCalendar:
Load
DATE($(vMinDate) + RowNo() -1) as Tempdate
AutoGenerate $(vMaxDate)-$(vMinDate)+1;

Re: Using AutoGenerate Function correctly

swuehl — Wed, 08 Feb 2017 21:24:58 GMT

Seems to work if you use numeric values for your variables:

SET DateFormat='DD.MM.YYYY';

GetDateRange:

Load

Min([Created At]) as MinDate,

Max([Created At]) as MaxDate

INLINE [

Created At

01.01.2017

22.12.2016

];

Let vMinDate=Peek('MinDate',0,'GetDateRange');

Let vMaxDate=Peek('MaxDate',0,'GetDateRange');

TempCalendar:

Load

DATE($(vMinDate) + RowNo() -1) as Tempdate

AutoGenerate $(vMaxDate)-$(vMinDate)+1;

topic Using AutoGenerate Function correctly in QlikView

Using AutoGenerate Function correctly

Re: Using AutoGenerate Function correctly