topic Unexpected error in QlikView

Unexpected error

Wed, 28 Mar 2012 08:47:43 GMT

Hola a todos / Hello,

Cuando ejecuto un informe, me aparece un Unexpected Error, comentándome que una fecha NO debería ir entre comillas, pero la fecha no va entre comillas.

Os adjunto la consulta para que me digáis porqué me aparece este error. /

When I run a report, I get an Unexpected Error, commenting that a date should NOT be quoted, but the date is not enclosed in quotation marks.

I attached the query to tell me why I get this error.

First 1000 LOAD AccountId as Id_Account,

Desempleado__c,

Participoante__c,

Baja__c,

FechaDeInicioRealDelCurso__c,

CodigoDelProyecto__c as Id_Proy;

SQL SELECT AccountId,

Desempleado__c,

Participante__c,

Baja__c,

FechaDeInicioRealDelCurso__c,

CodigoDelProyecto__c

FROM Opportunity WHERE Desempleado__c = True and Participante__c = 'Sí' and Baja__c = 'No' and FechaDeInicioRealDelCurso__c > 310511;

Muchas gracias / Thanks

César

Unexpected error

Jason_Michaelides — Wed, 28 Mar 2012 08:55:12 GMT

Sounds like a SQL error. Does

SELECT AccountId,

Desempleado__c,

Participante__c,

Baja__c,

FechaDeInicioRealDelCurso__c,

CodigoDelProyecto__c

FROM Opportunity WHERE Desempleado__c = True and Participante__c = 'Sí' and Baja__c = 'No' and FechaDeInicioRealDelCurso__c > 310511

work in SQL outside of QlikView?

Unexpected error

Wed, 28 Mar 2012 09:07:07 GMT

Its a Salesforce not SQL. Perhaps someone did it in Salesforce...

Thanks

Unexpected error

Jason_Michaelides — Wed, 28 Mar 2012 09:16:44 GMT

Are you connecting to SalesForce directly using the QlikView SalesForce connector? I have no experience using that I'm afraid. First step should be to verify the query works outside of QlikView, in any case.

Unexpected error

Wed, 28 Mar 2012 09:17:38 GMT

This error:

= 'Sí' and Baja__c = 'No' and FechaDeInicioRealDelCurso__c > 310511

ERROR at Row:6:Column:121

value of filter criterion for field 'FechaDeInicioRealDelCurso__c' must be of type date and should not be enclosed in quotes

SQL SELECT AccountId,

Desempleado__c,

Participante__c,

Baja__c,

FechaDeInicioRealDelCurso__c,

CodigoDelProyecto__c

FROM Opportunity WHERE Desempleado__c = True and Participante__c = 'Sí' and Baja__c = 'No' and FechaDeInicioRealDelCurso__c > 310511