topic Calendar from Field Component in QlikView

Calendar from Field Component

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Calendar from Field Component

vinieme12 — Wed, 28 Dec 2016 17:49:23 GMT

Please post the complete script

Re: Calendar from Field Component

Wed, 28 Dec 2016 17:54:13 GMT

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

Re: Calendar from Field Component

vinieme12 — Mon, 02 Jan 2017 15:08:53 GMT

have you tried by using other Master Calendar scripts?

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

Re: Calendar from Field Component

Anonymous — Mon, 02 Jan 2017 15:26:18 GMT

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!!!!

Re: Calendar from Field Component

Tue, 03 Jan 2017 19:16:07 GMT

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.