topic Error in loading master calendar in QlikView

Error in loading master calendar

Anonymous — Mon, 22 Feb 2016 02:19:08 GMT

Hi,

I have used Jos Good's script to load the Master calendar but I am receiving the following error message when loading:-

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Incorrect syntax near 'MAPPING'.

I am using "InvoiceDate".

Scripts loaded.

Script attached.

Any help appreciated.

Regards,

Laura

jagan — Mon, 22 Feb 2016 02:29:30 GMT

Hi,

You have to give ; at end of each statement

order by fa.accountnumber;

You have to replace Orders with your actual table name.

Temp:

Load

min( InvoiceDate) as minDate,

max( InvoiceDate) as maxDate

Resident MemberActiveProducts;

Hope this helps you.

Regards,

Jagan.