Solved: HOW TO REMOVE NULL IN CREATE DATE FIELD - Qlik Community

Report Inappropriate Content · ‎2016-02-01

CREATED DATE

PLEASE HELP ME ARGENT.

Peter_Cammaert · ‎2016-02-01

If I understand your issue correctly, it would be better to insert NULL values as a replacement of the non-date text values.

You can do this in your script like:

:

date#([CREATED DATE]) AS [CREATED DATE],

:

date#() will return NULL if it doesn't understand the current parameter value.

If the column date format doesn't match your default format, you will have to add a format string parameter to the date#() function call.

Best,

Peter

Peter_Cammaert · ‎2016-02-01

If I understand your issue correctly, it would be better to insert NULL values as a replacement of the non-date text values.

You can do this in your script like:

:

date#([CREATED DATE]) AS [CREATED DATE],

:

date#() will return NULL if it doesn't understand the current parameter value.

If the column date format doesn't match your default format, you will have to add a format string parameter to the date#() function call.

Best,

Peter

robert_mika · ‎2016-02-01

Probably the best is to use WHERE statement at the script level

Load

...

WHERE NOT IsNull(YourField);

Feeling Qlikngry?

Peter_Cammaert · ‎2016-02-01

If you display a field formatted like this in a listbox, there won't be any NULL values (or other non-date values) present. Problem solved.

Peter

jagan · ‎2016-02-01

Hi,

Try like this

Load

...

WHERE

Len(Trim(FieldName)) > 0 AND Upper(FieldName) <> 'NULL';

Hope this helps you.

Regards,

Jagan.