topic Re: In load set today date if empty in QlikView

In load set today date if empty

Tue, 07 Aug 2012 12:26:17 GMT

I have a EndField that are empty if it´s still in progress. For those I want to mark with today date today ()

Like this: In a other table the endfield are marked with with 99999999 for the post that are still active. There I use this fomula.

Date(if(EndField2= 99999999, Today(), Date#(EndField2, 'YYYYMMDD')), 'YYYY-MM-DD') as EndField2,

How to do it if it´s empty?

If it´s to any help the table with the empty endfield all empty post are marked as 0 in i other field, named XXX34

giakoum — Tue, 07 Aug 2012 12:29:37 GMT

IsNull(expr )

Returns -1 (true) if expr returns NULL, otherwise 0 (false).

Date(if(XXX34= 0, Today(), Date#(EndField2, 'YYYYMMDD')), 'YYYY-MM-DD') as EndField2,

strange field names...

swuehl — Tue, 07 Aug 2012 12:47:05 GMT

if( len(trim(EndField2))=0, ....

works also with blank fields or fields that contain only (soft) spaces.