Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

qvhelpplease
New Contributor II

null handling

please look at the file i attached where i wan to eliminate nulls in date fields

3 Replies

Re: null handling

try like this

if(len(trim(date))>0,Date)  as Date

if you want to eliminate the data where date is null then have a where condition like

LOAD *

from table

where len(trim(date))>0;

brijeshma
Contributor

Re: null handling

Hi You can try With multiple way .. depend on your data like

if(IsNull(Date),'Null',Date) as Date  OR

if(len(trim(date))>0,Date)  as Date

muthukumar77
Contributor III

Re: null handling

Hi,

Load *

from table

where len(trim(Date))<>0;

Muthukumar Pandiyan
Community Browser