Get error massage when i try to create master calendar

[#1]

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

[#2]

http://community.qlik.com/thread/100867

Hi Jonathan

can you advise me on the above link. which i learn from your blog.

[Alejandro_Hernández]

The problem is your bookmark ID's are not the same as the values in BMId.

Change your inline table to this:

LOAD * INLINE

[

   BMName, BMId

   Select TDSS, BM04

   Select ADL, BM05

];

and it should work.