Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Thanks everyone. I suppose I'll have to identify these fields manually and stick to the workaround tresesco suggests
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
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.
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.
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.
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.
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>;
Thanks everyone. I suppose I'll have to identify these fields manually and stick to the workaround tresesco suggests