topic Oracle SQL run in TOAD returns data in a field that shows as null in QlikView in QlikView https://community.qlik.com/t5/QlikView/Oracle-SQL-run-in-TOAD-returns-data-in-a-field-that-shows-as/m-p/1253465#M867392 <HTML><HEAD></HEAD><BODY><P>New to this so sorry if posting in wrong place</P><P>I have a load in Qlikview that returns Null value for one of the fields but when the SQL is run in toad the field returns a value.</P><P>Any help with this would be gratefully received.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Oracle SQL run in TOAD returns data in a field that shows as null in QlikView https://community.qlik.com/t5/QlikView/Oracle-SQL-run-in-TOAD-returns-data-in-a-field-that-shows-as/m-p/1253465#M867392 <HTML><HEAD></HEAD><BODY><P>New to this so sorry if posting in wrong place</P><P>I have a load in Qlikview that returns Null value for one of the fields but when the SQL is run in toad the field returns a value.</P><P>Any help with this would be gratefully received.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Oracle-SQL-run-in-TOAD-returns-data-in-a-field-that-shows-as/m-p/1253465#M867392 2020-11-25T16:16:04Z Re: Oracle SQL run in TOAD returns data in a field that shows as null in QlikView https://community.qlik.com/t5/QlikView/Oracle-SQL-run-in-TOAD-returns-data-in-a-field-that-shows-as/m-p/1253466#M867393 <HTML><HEAD></HEAD><BODY><P>What kind of field is that? Does the odbc or oledb driver you use support that type of field?</P></BODY></HTML> Tue, 13 Dec 2016 12:31:18 GMT https://community.qlik.com/t5/QlikView/Oracle-SQL-run-in-TOAD-returns-data-in-a-field-that-shows-as/m-p/1253466#M867393 Gysbert_Wassenaar 2016-12-13T12:31:18Z Re: Oracle SQL run in TOAD returns data in a field that shows as null in QlikView https://community.qlik.com/t5/QlikView/Oracle-SQL-run-in-TOAD-returns-data-in-a-field-that-shows-as/m-p/1253467#M867394 <HTML><HEAD></HEAD><BODY><P>the field is a receipt number from the PO ledger, the strange thing is that on some of the returned rows there is a receipt number for exactly the same AP invoice but a different PO number.</P><P>attached is the SQL from the Load. it creates a QVD</P></BODY></HTML> Tue, 13 Dec 2016 14:25:59 GMT https://community.qlik.com/t5/QlikView/Oracle-SQL-run-in-TOAD-returns-data-in-a-field-that-shows-as/m-p/1253467#M867394 2016-12-13T14:25:59Z Re: Oracle SQL run in TOAD returns data in a field that shows as null in QlikView https://community.qlik.com/t5/QlikView/Oracle-SQL-run-in-TOAD-returns-data-in-a-field-that-shows-as/m-p/1253468#M867395 <HTML><HEAD></HEAD><BODY><P>you're seeing null values ('-') in Data Model or in front end?</P><P>Sometimes in Data Model it doesn't show you any value but if you bring that field in front end you'll see values.</P></BODY></HTML> Tue, 13 Dec 2016 15:01:20 GMT https://community.qlik.com/t5/QlikView/Oracle-SQL-run-in-TOAD-returns-data-in-a-field-that-shows-as/m-p/1253468#M867395 MK9885 2016-12-13T15:01:20Z