topic Never ending script execution in QlikView

Never ending script execution

Sat, 09 Feb 2013 07:43:45 GMT

Hello all,

I am quite new with qvw, I have tried to create a master calendar to show only years from 2008 to 2030. Following instructions I've found in the community I managed to set it up but when I hit RELOAD the script runs for more than 10mins while the AUTOGENERATE (1) stops at 187.876.841.

should I start thos from scratch?!

thanks all

Re: Never ending script execution

er_mohit — Sat, 09 Feb 2013 08:00:09 GMT

hiiii

try this

// Calender

LET vDateMin = Num(MakeDate(2008,1,1));

LET vDateMax = Floor(MakeDate(2030,12,31));

LET vDateToday = Num(Today());

TempCalendar:

LOAD

$(vDateMin) + RowNo() - 1 AS DateNumber,

Date($(vDateMin) + RowNo() - 1) AS TempDate

AUTOGENERATE 1

WHILE $(vDateMin)+IterNo()-1<= $(vDateMax);

Calender:

LOAD

Date(TempDate,'DD-MM-YYYY' ) AS CalendarDate,

Year(TempDate) AS CalendarYear

RESIDENT TempCalendar ORDER BY TempDate ASC;

DROP TABLE TempCalendar;

Re: Never ending script execution

Sat, 09 Feb 2013 08:06:29 GMT

ity worked!

thanks!