topic Re: Filtering data in load script in QlikView

Filtering data in load script

ashis — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In my load script i have a date field xxx as

date(xxx, 'DD/MM/YYYY hh:mm:ss tt') as xxx,

based on this field i want to filter my data . So in the where clause i put

where DATE(xxx,'DD/MM/YYYY hh:mm:ss tt')>'12/11/2017 00:00:00 AM' ;

My problem is I only get data after 12/11/2017 for year 2017 but 2018 data is not coming.

Thank you,

Ashis

sunny_talwar — Tue, 16 Jan 2018 09:13:19 GMT

Is this where clause used in SQL SELECT statement or LOAD statement? Also, are you sure you have data for 2018 in your source data?

ashis — Tue, 16 Jan 2018 09:21:20 GMT

This is used in Load statement , reading data from QVD. Yes I do have data for 2018.

If I remove where clause I do get data for Jan- 2018.

sunny_talwar — Tue, 16 Jan 2018 09:23:27 GMT

Can you try this

Where xxx > MakeDate(2017, 12, 11);

ashis — Tue, 16 Jan 2018 09:29:16 GMT

Great, it works... Thank you Sunny.

ashis — Tue, 16 Jan 2018 10:02:04 GMT

Any guess why my piece of code breaking.

sunny_talwar — Tue, 16 Jan 2018 12:27:33 GMT

Difficult to say, but my guess is that it is unable to read he string as a date... it is doing something else which is why there are issues....