How to load null dates also while loading into report

[gyuvaraj]

Hi All,

I have date column with null values, using date column i have to load last 5 years records into qlikview but here its working fine but null values are excluded while loading into qlikview.

Example:

load * from tablename  where year(date) > year(today())-5;

here i have to load null dates also into report after excluding last 5 years.

Thanks,

Yuvaraj

[Vegar]

Maybe this will solve your issue

load * from tablename where NOT (year(date) <= year(today())-5) ;

[gyuvaraj]

Hi,

Thanks for your reply.

Applied same but its excluding null values but am expecting last 5 year records with null values too.

Regards,

Yuvaraj

[MayilVahanan · Accepted solution]

Hi @gyuvaraj 

Am not sure, why u need to load null dates also.

Try like this

load * from tablename  where (year(date) > year(today())-5 or Len(Trim(date))=0);