topic Returning Null values in date field in QlikView

Returning Null values in date field

Mon, 27 Feb 2012 08:53:15 GMT

Upon loading a table from a database, I am trying to put a where clause on the load so that it only loads records where the value in a date field reads NULL.

I have tried a range of expressions including the simplest I would anticipate working which was:

Where "ASS_DISP_DATE" = 'NULL';

with "Ass_Disp_date' being the datefield I want to apply the restriction to. However everything I try returns the following error message:

"Conversion failed when converting datetime from charcter string"

If anybody could advise me on the correct syntax that I should be using to solve this problem then it would be much appreciated.

Kind Regards,

Steve

Returning Null values in date field

CELAMBARASAN — Mon, 27 Feb 2012 09:03:07 GMT

Hi,

If you are loading from excel file then you can use this

"ASS_DISP_DATE" = NULL();

If you are loading it from database then use

"ASS_DISP_DATE" IS NULL;

Hope it helps

Celambarasan

Re: Returning Null values in date field

Mon, 27 Feb 2012 09:04:52 GMT

Hi,

Try to convert the date field to string and then see.I think it will work then.Let me know if you need more

help on this.

Regards

Navin.G

Returning Null values in date field

Mon, 27 Feb 2012 09:05:16 GMT

What about: Where LEN(TRIM(ASP_DISP_DATE)) < 1;