Discussion Board for collaboration on QlikView Scripting.
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');
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?
Go to Solution.
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!