topic Re: Get error massage when i try to create master calendar in QlikView

Get error massage when i try to create master calendar

Mon, 26 Jan 2026 18:19:17 GMT

Hi All

I get following error msg :-

Script line error:

TempCalendar:

LOAD

+ rowno() - 1 AS Num,

date( + rowno() - 1) AS TempDate,

date( + rowno() - 1) AS D,

year( + rowno() - 1) AS Y,

month( + rowno() - 1) AS M,

date(monthstart( + rowno() - 1), 'MMM-YYYY') AS MY

AUTOGENERATE - + 1

Can some one share with me where i go wrong ?

Paul

Re: Get error massage when i try to create master calendar

Wed, 04 Dec 2013 04:55:31 GMT

Hi Paul

Try The below script.. Hope it will help

AutoGenerationDate:

Load

RecNo( ) as A,

if(RecNo()=1,date(MakeDate(2001,1,1)),date((Peek("AutoDate")+1))) as AutoDate,

date(if(RecNo()=1,date(MakeDate(2001,1,1)),date((Peek("AutoDate")+1))),'DD/MM/YYYY') as AutoDate_new,

year(if(RecNo()=1,date(MakeDate(2001,1,1)),date((Peek("AutoDate")+1)))) as AutoYear,

Month(if(RecNo()=1,date(MakeDate(2001,1,1)),date((Peek("AutoDate")+1)))) as NormalMonth,

MonthName(if(RecNo()=1,date(MakeDate(2001,1,1)),date((Peek("AutoDate")+1)))) as My,

if(wildmatch(month((if(RecNo()=1,date(MakeDate(2001,1,1)),date((Peek("AutoDate")+1))))),'Jan','Feb','Mar'),year((if(RecNo()=1,date(MakeDate(2001,1,1)),date((Peek("AutoDate")+1)))))-1,year((if(RecNo()=1,date(MakeDate(2001,1,1)),date((Peek("AutoDate")+1)))))) as Fin_Year,

if(month((if(RecNo()=1,date(MakeDate(2001,1,1)),date((Peek("AutoDate")+1)))))<=3,month((if(RecNo()=1,date(MakeDate(2001,1,1)),date((Peek("AutoDate")+1)))))+9,month((if(RecNo()=1,date(MakeDate(2001,1,1)),date((Peek("AutoDate")+1)))))-3) as Fin_Month

autogenerate(50000);

Left Join(AutoGenerationDate)

//Entry_DT_QTR:

LOAD * INLINE [

Fin_Month, Month_New,QTR

1, Apr,Q1

2, May,Q1

3, Jun,Q1

4, Jul,Q2

5, Aug,Q2

6, Sep,Q2

7, Oct,Q3

8, Nov,Q3

9, Dec,Q3

10, Jan,Q4

11, Feb,Q4

12, Mar,Q4

];

Re: Get error massage when i try to create master calendar

Wed, 04 Dec 2013 05:27:42 GMT

Hi sir

Thank you for your script very special.

The 2 table not link by date field.

i try to link by Date field.

But it cannot work.

Re: Get error massage when i try to create master calendar

Wed, 04 Dec 2013 05:32:10 GMT

Can you post your application

Re: Re: Get error massage when i try to create master calendar

Wed, 04 Dec 2013 05:37:06 GMT

see my QV doc

Re: Re: Re: Get error massage when i try to create master calendar

Wed, 04 Dec 2013 05:43:30 GMT

try to reload now

Re: Get error massage when i try to create master calendar

Wed, 04 Dec 2013 05:47:42 GMT

Hi Paul,

You are just missing a comma after "MY". Try this:

TempCalendar:

LOAD
+ rowno() - 1 AS Num,
date( + rowno() - 1) AS TempDate,
date( + rowno() - 1) AS D,
year( + rowno() - 1) AS Y,
month( + rowno() - 1) AS M,
date(monthstart( + rowno() - 1), 'MMM-YYYY') AS MY,
AUTOGENERATE - + 1
;
Hope this helps!

Re: Get error massage when i try to create master calendar

Wed, 04 Dec 2013 06:58:30 GMT

Hi Shy

After add the comma , the error msg go away.

Now another issue came out , it does generate a calendar table.

Why ?

Re: Get error massage when i try to create master calendar

Wed, 04 Dec 2013 07:03:40 GMT

Hi Paul,

Not sure if I understand you. Can you elaborate a little?

Re: Get error massage when i try to create master calendar

Wed, 04 Dec 2013 07:04:47 GMT

Have you try the below one

Re: Re: Get error massage when i try to create master calendar

Wed, 04 Dec 2013 07:14:37 GMT

Hi Sir

After no error , it should generate 1 table for master calendar . but table does appear. only 1 table appear.

see the enclsoed QV doc.

Re: Get error massage when i try to create master calendar

Wed, 04 Dec 2013 07:21:11 GMT

Hi Nir

what do you mean have i try below one ?

Re: Get error massage when i try to create master calendar

jonathandienst — Wed, 04 Dec 2013 07:28:43 GMT

Paul

It looks like you have a variable that is undefined. For example, the first line

+ Rowno() - 1 as Num

is probably something like (

$(vStart) + Rowno() - 1 as Num

and vStart is undefined. I dont know the actual variable name in your script (I cant open the qvw you uploaded), so replace vStart with the correct variable name.

HTH

Jonathan

Re: Re: Get error massage when i try to create master calendar

Wed, 04 Dec 2013 07:41:00 GMT

Hi Sir

I add the 2 var name you mean i missing . i also put in some value , but each time i enter , it get missing.

Re: Re: Re: Get error massage when i try to create master calendar

Alejandro_Hernández — Wed, 04 Dec 2013 07:44:52 GMT

fixed it for you

Re: Get error massage when i try to create master calendar

jonathandienst — Wed, 04 Dec 2013 07:49:18 GMT

Paul

Not sure why you need two steps to get the min and max dates. This means you have two tables containing MinDate and MaxDate as fields.Perhaps this is confusing the Peek, because I see that varMinDate and varMaxDate are both blank.

tmp:

LOAD

min(Date) AS MinDate,

max(Date) AS MaxDate

RESIDENT ABSEN;

LET varMinDate = Num(Peek('MinDate'));

LET varMaxDate = Num(Peek('MaxDate'));

LET vToday = num(today());

DROP TABLE tmp;

HTH

Jonathan

Re: Re: Get error massage when i try to create master calendar

Wed, 04 Dec 2013 07:57:07 GMT

Hi Alej,

Now when i add below script to get the field for calendar , i get error msg.

MasterCalendar:

LOAD TempDate AS date,

Dual(Right(Year(TempDate), 2), YearStart(TempDate)) as year_

RESIDENT TempCalendar

ORDER BY TempDate ASC;

DROP TABLE TempCalendar;

any idea why ?

Table not found

MasterCalendar:

LOAD TempDate AS date,

Dual(Right(Year(TempDate), 2), YearStart(TempDate)) as year_

RESIDENT TempCalendar

ORDER BY TempDate ASC

Re: Re: Get error massage when i try to create master calendar

Wed, 04 Dec 2013 07:59:07 GMT

Hi Jona

you are very right , my mistake . as i use my old script which . because last time some one give the script to me. now no more error , because some one have fix the problem. now next problem.

Re: Get error massage when i try to create master calendar

Wed, 04 Dec 2013 08:47:06 GMT

Hi All

Thank you very one here for your help.

I manage to solve the problem.

Paul

Re: Get error massage when i try to create master calendar

Wed, 04 Dec 2013 08:57:17 GMT

Hi Paul

Sorry.... wrong entry