Calendar from Field Component

[#1]

Hello,

I am having issues using the "Calendar from Field" component. I am getting the following error.

Script line error:

LOAD date('' + recno() - 1) as Date,

  date('' + recno() - 1) as _qvctemp.Date

AUTOGENERATE date('') - date('') + 1

If I load my date field as such "Date(Date#([Create Date],'MM/DD/YYYY hh:mm'),'MM/DD/YYYY') as Date", Then I dont get the error above, but then all the Calendar list-boxes show empty.

Any thoughts?

[vinieme12]

Please post the complete script

[#3]

Its part of the Qlikview components pack "Calendar from Field", I don't know how I would open the full script .

[vinieme12]

have you tried by using other Master Calendar scripts?

https://qlikviewcookbook.com/2015/05/better-calendar-scripts/

[Anonymous]

Hi Jhancer,

Try this:

MinMaxDate:

LOAD

     Min(Date)          as MinDate,

     Max(Date)          as MaxDate

RESIDENT YourTable;

LET vMinDate = Date(Floor(Peek('MinDate',0,'MinMaxDate')));

LET vMaxDate = Date(Floor(Peek('MaxDate',0,'MinMaxDate')));

Calendar:

LOAD $(vMinDate) + recno() - 1 as Date,

          $(vMinDate) + recno() - 1 as _qvctemp.Date

AUTOGENERATE $(vMaxDate) - $(vMinDate) + 1;

Regards!!!!

[#6]

So it seems that it was an issue with the date format. I changed the date format of the raw data (it was an excel file) and then all worked fine.