topic URGENT DATE in QlikView

URGENT DATE

Sun, 06 Jun 2010 08:33:40 GMT

HI,

THIS MY FILE PLEASE APPLY THE MASTER CALENDER FOR MY FILE I FOLLOWED THE STEPS BUT THERE IS ERROR .

ANY ONE HERE KNOW WHY IT SHOW ME THIS ERROR.

Script line error:
TempCalendar:
LOAD
39097 + rowno() - 1 AS DateNumber,
date(39097 + rowno() - 1) AS
TempDate
AUTOGENERATE
39034 - 39097 + 1

THIS IS MESSAGE PLEASE TELL ME THE REASONS

THIS MY CODE FOR TEMPORARY CALENDAR

TempCalendar:

LOAD

$(varMinDate) + rowno() - 1 AS DateNumber,

date($(varMinDate) + rowno() - 1) AS

TempDate

AUTOGENERATE

$(varMaxDate) - $(varMinDate) + 1;

REGARDS

ABDALLA.

URGENT DATE

Anonymous — Mon, 07 Jun 2010 06:43:30 GMT

Abdalla,

It looks like you're trying to generate a negative number of rows? 39034 - 39097 + 1 = -62

Make sure that your varMaxDate is larger than your varMinDate.

URGENT DATE

Mon, 07 Jun 2010 08:37:20 GMT

Hi,

You're right. Already I attached file along with post could you please open it and try to see how the solution will be.

Regards,

Abdalla

URGENT DATE

Mon, 07 Jun 2010 09:07:24 GMT

Hi Abdullah

try to use the following code to build your calender

let varminDate = num(peek('OrderDate',0,'Order'));

let varmaxDate = num(peek('OrderDate',-1,'Order'));

calender_tmp:

Load

$(varminDate) + rowno() -1 as Num,

date ($(varminDate)+rowno()-1) as TempDate

autogenerate $(varmaxDate) - $(varminDate)+1;

MasterCalender:

load

TempDate as OrderDate,

week(TempDate) as Week,

Year(TempDate) as Year,

Month(TempDate) as Month,

Day(TempDate) as Day

resident calender_tmp order by TempDate;

drop table calender_tmp;

URGENT DATE

Mon, 07 Jun 2010 12:32:01 GMT

Hi M.OWN,

Thanks bro I applied this code, but still it 's not working and again given error did u checked in your qlikview and it's working,

Regards,

Abdalla

URGENT DATE

Mon, 07 Jun 2010 12:33:46 GMT

hello

see error coming from my system

Script line error:
calender_tmp:

Load

+ rowno() -1 as Num,

date (+rowno()-1) as TempDate

autogenerate - +1

URGENT DATE

Mon, 07 Jun 2010 13:39:59 GMT

Hi Abdullah,

there is something wrong with your data, i don't know what exactly , any way you can replace min & max variable as following line and it will work with you.

let varminDate = num(Date('01/01/2004'));

let varmaxDate = num(date('31/12/2010'));