Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Reload problem. Where Clause causing field to go null

I am loading the inventory history transaction table from IFS (PL/SQL) using the following script:

select

     transaction_code,

     date_created,

     cost

from IFSAPP.INVENTORY_TRANSACTION_HIST_TAB;

this loads the whole table which is massive so I have been trying to restrict it to one year:

select

     transaction_code,

     date_created,

     cost

from IFSAPP.INVENTORY_TRANSACTION_HIST_TAB

where TO_CHAR(DATE_CREATED,'YYYY') = '2018';


this works except the cost field shows only null values.


Has anyone else encountered this problem?

12 Replies
wdchristensen
Specialist
Specialist

If you pull the data for a different year is it populated? Is so, maybe the cost field has not been populated yet for 2018.

shiveshsingh
Master
Master

What's the o/p in sql developer? Are you getting values?

select

     transaction_code,

     date_created,

     cost

from IFSAPP.INVENTORY_TRANSACTION_HIST_TAB

where TO_CHAR(DATE_CREATED,'YYYY') = '2018';

sunny_talwar

May be try this

SELECT

     transaction_code,

     date_created,

     cost,

     TO_CHAR(DATE_CREATED,'YYYY') year

from IFSAPP.INVENTORY_TRANSACTION_HIST_TAB;

Do you see year 2018 and in those rows does cost have any value?