topic Re: How to load null dates also while loading into report in QlikView

How to load null dates also while loading into report

gyuvaraj — Fri, 15 Nov 2024 23:43:14 GMT

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

Re: How to load null dates also while loading into report

Vegar — Thu, 29 Oct 2020 09:06:52 GMT

Maybe this will solve your issue

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

Re: How to load null dates also while loading into report

gyuvaraj — Thu, 29 Oct 2020 09:11:42 GMT

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

Re: How to load null dates also while loading into report

MayilVahanan — Thu, 29 Oct 2020 09:14:19 GMT

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);