topic Re: Field DataTypes in QlikView

Field DataTypes

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

Is there a way in Qlikview to see the data type of each field in the data model and convert it at reload time?

Regards,

Re: Field DataTypes

Kushal_Chawda — Tue, 07 Jun 2016 07:08:08 GMT

You can see the field tags in Document properties->Tables

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Document_Properties_Tables.htm

Re: Field DataTypes

tresB — Tue, 07 Jun 2016 07:08:55 GMT

There are no data types in qv: Data Types in QlikView

May be you meant it for something else. That could probably be done/worked with. But you have to explain it in more details for that.

Re: Field DataTypes

maleksafa — Tue, 07 Jun 2016 07:11:38 GMT

basically in qlikview there are no data types, however you can format the fields or convert them into specific data types (but still even after that they can have any data type). to override a data type, you can go to document properties and then tables.

Re: Field DataTypes

bindu_apte — Tue, 07 Jun 2016 07:15:16 GMT

There are no data types in QlikView:

There are different presentation of the numeric data, that's it. But you can't even say that a given column is a numeric or a text, because both numeric and string values can be in the same column in QlikView.

Re: Field DataTypes

Tue, 07 Jun 2016 07:16:24 GMT

Hi Treseco

I had a problem when I read a field from a SQL table with a "bit" data type. This field contained 0 and 1 values in the DB but in QV the values were 0 and -1. I had to convert the Data Type to "int" using a SQL CAST statement in order to get the correct values. This took a long time for me to find what the issue was and I just wanted to know if there is an easy way to find all the fields with the "bit" data type in my data model without having to check on the source DB.

Re: Field DataTypes

tresB — Tue, 07 Jun 2016 07:20:47 GMT

This is because, for qv TRUE is -1. For that specific field you may read in qv like:

Load

(BitValue)*(-1) as BitValue

From <SQLSource>;

Re: Field DataTypes

Tue, 07 Jun 2016 07:27:32 GMT

Thanks everyone. I suppose I'll have to identify these fields manually and stick to the workaround tresesco suggests