qlikview loads the columns as null - Page 2 - Qlik Community

Report Inappropriate Content · ‎2017-09-24

Hi All

I have a table with columns defined in oracle as varchar2(4000). When I do a simple load of this column it shows as null in the list box or table chart.

Qlikview Table viewer also fails to recognize the column values and displays just null
Tried num, num# and text and a combination of these but nothing helped

Any help please.

Regards

Prashant

Peter_Cammaert · ‎2017-09-27

Try using ...TO_CHAR(COL1) "COL1_CHAR"... in your SQL SELECT statement, before sending the data through ODBC to QlikView.

Report Inappropriate Content · ‎2017-09-30

I tried to_char and it did not work. Also tried to_number but no success.

marcus_sommer · ‎2017-09-30

I would check directly in the database how the content of these fields look like and if they could be transformed. I mean to use a query with len(), isnum(), istext() and similar checks and also several transformations with cast(), to_char(), to_number() and similar to look if it worked there.

A following step might be to create a table-dump with this kind of query and then to pull this dump into qlikview.

Beside this I would try to pull various tables/fields (only a few records) into qlik to see if there are other salience with NULL's, wrong formattings and/or values.

- Marcus