My query runs in SQL Developer on Oracle, and returns 4 rows. When I put the query into a script in Qlikview, it only returns 3 rows. I think the issue may be around date format, but it looks OK, and I have forced the format to be consistent in Oracle. Anyone any ideas?
