Date where clause odd behaviour...

juleshartley — Tue, 11 Feb 2014 12:19:01 GMT

Hi All,

I have a strange situation in my load script. All that I am doing is filtering on a specific date using the following logic:

let vCurDate = date(peek('%keyDate'),'DD/MM/YYYY');

Load

resident Temp

where %keyDate = '$(vCurDate)';

Now, even though there is data, the above returns no results. HOWEVER, if I put > rather than = in the where clause then it does return the date equal to that date (and above of course).

Can anyone help explain this strange behaviour?

Thanks!

Re: Date where clause odd behaviour...

juleshartley — Tue, 11 Feb 2014 12:35:48 GMT

Figured this out myself - I had created the key using a monthend function, which I think leaves a time on the end of the date... so I used a floor() to remove this and all is fine!

topic Date where clause odd behaviour... in QlikView

Date where clause odd behaviour...

Re: Date where clause odd behaviour...