Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
lauracastagna
Creator II
Creator II

Error in loading master calendar

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

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

1 Reply
jagan
Luminary Alumni
Luminary Alumni

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.