URGENT DATE

[#1]

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.

[Anonymous]

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.

[#3]

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

[#4]

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;

[#5]

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

[#6]

hello

see error coming from my system

Script line error:
calender_tmp:

Load

+ rowno() -1 as Num,

date (+rowno()-1) as TempDate

autogenerate - +1

[#7]

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'));