Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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

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.

3 Replies
MVP & Luminary
MVP & Luminary

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

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


talk is cheap, supply exceeds demand
Not applicable

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

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
Honored Contributor II

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

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.