Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What kind of field is that? Does the odbc or oledb driver you use support that type of field?
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
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.