topic Re: Needed help for generating dates from this year starting on wards to till date in QlikView

Needed help for generating dates from this year starting on wards to till date

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

Hi all,

This is the script for generating dates from year start of 2016 to end of 2016.

Cal:

load

if(RecNo()=1,YearStart(today()),date(peek(date)+1)) as date

AutoGenerate Yearend(Today())-YearStart(today())+1;

So in the same way can anyone help me with generating complete dates from January 1st 2016 to 16 th march 2016.

Thanks in advance,

Madhu

Re: Needed help for generating dates from this year starting on wards to till date

tamilarasu — Wed, 16 Mar 2016 07:58:01 GMT

Hi,

Check the below script.

Let varMinDate = Num(Makedate(2016,01,01));
Let varMaxDate = Num(Makedate(2016,12,31));

Date:
LOAD
date($(varMinDate)+IterNo()-1) AS Datefield
AUTOGENERATE (1)
WHILE $(varMinDate)+IterNo()-1<= $(varMaxDate);

If you want to generate date for current year, you can change the variables as

Let varMinDate = Num(Yearstart(Today()));

Let varMaxDate = Num(YearEnd(Today()));

Re: Needed help for generating dates from this year starting on wards to till date

ali_hijazi — Wed, 16 Mar 2016 08:00:05 GMT

let vStartDate = ; num(YearStart(Today()))

let vEndDate = num(Daystart(Today()));

TempCalendar:

load recno() as DateKey,

$(vStartDate) + recno() - 1 as PeriodDate

autogenerate ($(vEndDate) - $(vStartDate) + 1);

Re: Needed help for generating dates from this year starting on wards to till date

tamilarasu — Wed, 16 Mar 2016 08:13:37 GMT

Just missed your second question.

Current year start to till date:

Let varMinDate = Num(Yearstart(Today()));

Let varMaxDate = Num(Today());

Current Year:

Let varMinDate = Num(Yearstart(Today()));

Let varMaxDate = Num(YearEnd(Today()));