Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Field DataTypes

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,

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

7 Replies
Highlighted
MVP
MVP

Highlighted
MVP
MVP

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.

Highlighted
Specialist
Specialist

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.

Highlighted
Creator III
Creator III

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.

Highlighted
Not applicable

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.

Highlighted
MVP
MVP

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>;

Not applicable

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

View solution in original post