How to display "Unknown" for missing dates

[qlikmsg4u]

Hi Members,

I am new to qlikview, i want to know if there is any way to display "Unknown" for any missing date.

ex: in my table i have two fields

name,  dob

a,5/12/1990

b,9/02/1995

c,

d,

if i want to show dob unknown for c and d in a list box how can i achieve this ?

[Anonymous]

in a listbox you can select under "formula" the symbols for null and missing values. there you can define "unknown"

in a Chart the same under presentation

[deepakqlikview_123]

or u can simply use if (dob='','unknown',dob) as dob;

[qlikmsg4u]

i tried the thing replace - by "unknown" in null values but it is not displaying in list box.any suggestions

[simondachstr]

Try setting set NullDisplay='Unknown'; before loading the table (Haven't tested it).

[qlikmsg4u]

i tried this one also but no use..

here is my script..

LOAD name,

     date(if(dob='','Unknown',dob),'MM/DD/YYYY') as dob1

FROM

[..\New Microsoft Office Excel Worksheet.xlsx]

[qlikmsg4u]

not working

[#8]

hi ,

Try Like this ,

if (len(trim(dob))=0,'unknown',dob) as dob;

Thanks !!!

[MK_QSL]

Load

  name,

  if(LEN(TRIM(dob))=0 or IsNull(dob), 'Unknown',dob) as dob;

Load

  name,

  Date(Date#(dob,'M/DD/YYYY')) as dob

Inline

[

  name,   dob

  a, 5/12/1990

  b, 9/02/1995

  c,

  d,

];

[amit_saini]

Try this:

=If( dob <>0, dob, ' Unknown')

Thanks,
AS