Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Unexpected error

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

4 Replies
jason_michaelid
Not applicable

Unexpected error

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?

Not applicable

Unexpected error

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

Thanks

jason_michaelid
Not applicable

Unexpected error

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.

Not applicable

Unexpected error

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