Oracle SQL run in TOAD returns data in a field that shows as null in QlikView

[#1]

New to this so sorry if posting in wrong place

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.

Any help with this would be gratefully received.

[Gysbert_Wassenaar]

What kind of field is that? Does the odbc or oledb driver you use support that type of field?

[#3]

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.

attached is the SQL from the Load. it creates a QVD

[MK9885]

you're seeing null values ('-') in Data Model or in front end?

Sometimes in Data Model it doesn't show you any value but if you bring that field in front end you'll see values.