topic Oracle query issue when in Qlikview in QlikView https://community.qlik.com/t5/QlikView/Oracle-query-issue-when-in-Qlikview/m-p/1083776#M640115 <HTML><HEAD></HEAD><BODY><P>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?</P><P>thanks</P></BODY></HTML> Thu, 03 Mar 2016 13:50:55 GMT 2016-03-03T13:50:55Z Oracle query issue when in Qlikview https://community.qlik.com/t5/QlikView/Oracle-query-issue-when-in-Qlikview/m-p/1083776#M640115 <HTML><HEAD></HEAD><BODY><P>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?</P><P>thanks</P></BODY></HTML> Thu, 03 Mar 2016 13:50:55 GMT https://community.qlik.com/t5/QlikView/Oracle-query-issue-when-in-Qlikview/m-p/1083776#M640115 2016-03-03T13:50:55Z Re: Oracle query issue when in Qlikview https://community.qlik.com/t5/QlikView/Oracle-query-issue-when-in-Qlikview/m-p/1083777#M640116 <HTML><HEAD></HEAD><BODY><P>ah! Sorted!!! </P></BODY></HTML> Thu, 03 Mar 2016 14:10:34 GMT https://community.qlik.com/t5/QlikView/Oracle-query-issue-when-in-Qlikview/m-p/1083777#M640116 2016-03-03T14:10:34Z