topic Re: qlikview loads the columns as null in QlikView

qlikview loads the columns as null

Sun, 24 Sep 2017 21:40:02 GMT

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

Re: qlikview loads the columns as null

Anil_Babu_Samineni — Mon, 25 Sep 2017 02:50:53 GMT

Can you show two different images which are they Oracle and QlikView to look? Varchar2() indicates Number + Text format in DB.

Re: qlikview loads the columns as null

Mon, 25 Sep 2017 03:39:37 GMT

Thanks much for replying.

Below Image from Oracle client

Image from Qlikview with no values and it is null as indicated in the third col

Re: qlikview loads the columns as null

its_anandrjs — Mon, 25 Sep 2017 03:45:02 GMT

Can you provide few rows in any qvd to have a look for the solution.

Re: qlikview loads the columns as null

Anil_Babu_Samineni — Mon, 25 Sep 2017 03:58:09 GMT

I am not facing any issue while loading from external DB(I have Postgresql). I believe if one DB source working as expected it should work in Other DB's too

My Qlikview

DB Image Attached. Not sure, What if you used Trim(FieldName) as Fieldname in Qlikview?

Re: qlikview loads the columns as null

Mon, 25 Sep 2017 05:29:03 GMT

I am surprised as well. not sure why is it happening.

Can there be some database env variable which may impact. Beside as mentioned earlier the qlik Table viewer also does not show any values.
Tried Trim(fieldname) as fieldname but not help
I can only provide rows from toad but that will work because it will be excel in that case

Re: qlikview loads the columns as null

Anil_Babu_Samineni — Mon, 25 Sep 2017 05:40:17 GMT

Okay, third one won't help because we are picking the same inputs if we have Oracle then will try but not having. And, Can you try different data source from your end and check if it is still there..

May be try any one of these

Trim(Field) as Field

Floor(Field) as Field

Ceil(Field) as Field

Text(Field) as Field

Num, Num# etc..

Re: qlikview loads the columns as null

Tue, 26 Sep 2017 18:00:29 GMT

Thanks Anil

I tried all of the above and unfortunately it did not work.

Re: qlikview loads the columns as null

Anil_Babu_Samineni — Tue, 26 Sep 2017 18:03:10 GMT

Looks like weird behavior. Let me invite marcus_sommer‌‌ and/or pcammaert

Re: qlikview loads the columns as null

marcus_sommer — Wed, 27 Sep 2017 07:20:37 GMT

I assume that rather the database-driver couldn't handle this varchar2(4000) and if I look on your data-example - just numbers - it doesn't look really suitable. I think I would try to convert these values with cast or to-number on the sql-level into a double fieldtype or something similar if the values are not mandatory numbers.

- Marcus

Re: qlikview loads the columns as null

Peter_Cammaert — Wed, 27 Sep 2017 09:02:48 GMT

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

Re: qlikview loads the columns as null

Sat, 30 Sep 2017 06:10:54 GMT

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

Re: qlikview loads the columns as null

marcus_sommer — Sat, 30 Sep 2017 07:37:17 GMT

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