topic null handling in QlikView

null handling

Anonymous — Sun, 19 Jun 2016 19:10:51 GMT

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

avinashelite — Mon, 20 Jun 2016 05:45:43 GMT

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;

brijeshvma — Mon, 20 Jun 2016 05:53:52 GMT

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 — Mon, 20 Jun 2016 07:45:18 GMT

Hi,

Load *

from table

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