Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
juleshartley
Valued Contributor

Date where clause odd behaviour...


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!

1 Solution

Accepted Solutions
juleshartley
Valued Contributor

Re: Date where clause odd behaviour...

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!

1 Reply
juleshartley
Valued Contributor

Re: Date where clause odd behaviour...

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!

Community Browser