topic Re: Where clause in QlikView

Where clause

Anonymous — Wed, 27 Nov 2013 13:10:21 GMT

Trying to filter but the error prevails.Please advice thanks

tresB — Wed, 27 Nov 2013 13:16:50 GMT

Check if the date in the DB field format is same as 'YYYY-MM-DD' or not. May be the different date format comparison causing the error.

Clever_Anjos — Wed, 27 Nov 2013 13:38:55 GMT

ORA-12801 usually has another error associated, please scroll right the screen and check

It seems to start with ORA-018....

Clever_Anjos — Wed, 27 Nov 2013 13:44:48 GMT

If its a date formatting issue you could try

MAN_ITEM_REPORT_DATE > TO_DATE('2010-01-01','YYYY-MM-DD')

Anonymous — Wed, 27 Nov 2013 14:59:00 GMT

This is the full error message displayed;

ErrorSource: OraOLEDB, ErrorMsg: ORA-12801: error signaled in parallel query server P179

ORA-01861: literal does not match format string

MANIFEST:

FIRST 1000

SELECT * from MANIFEST_ITEMS

WHERE MAN_ITEM_REPORT_DATE > '2010-01-01'

Anonymous — Wed, 27 Nov 2013 15:25:37 GMT

This is how QV displays it when the filter is rem out

Clever_Anjos — Wed, 27 Nov 2013 15:26:42 GMT

Try

Where

MAN_ITEM_REPORT_DATE > TO_DATE('2010-01-01','YYYY-MM-DD')

VishalWaghole — Wed, 27 Nov 2013 17:42:45 GMT

Hi Adotey Kwame,

Its not only Date Format, Its Date with Timestamps format

so you will need to do Query Like this..

MANIFEST:

FIRST 1000

SELECT * from MANIFEST_ITEMS

WHERE MAN_ITEM_REPORT_DATE > to_date('2010-01-01 00:00:00', 'YYYY:MM:DD HH24:MI:SS')

Thanks and Regards,

Vishal Waghole

Anonymous — Wed, 27 Nov 2013 18:34:06 GMT

See my old document here, maybe it helps: http://community.qlik.com/docs/DOC-1321