Field Types In A QlikView Document

[rebelfox]

I have inherited a Qlikview document with loads of tables and columns.

I can view the tables in the 'Table Viewer' screen that shows how all the tables link to each other but is a way to identify the field type in of a given column the same way as you would for  in Crystal Reports ( string, decimal, date etc )?.

[#2]

Hi,

Once the script is finished, you can see the type of fields in Settings -> Document Properties -> Tables

Thanks,

Itishree

[ThornOfCrowns]

There are two types - numeric and string. QlikView holds all loaded data as both types, simultaneously.

[Saravanan_Desingh · Accepted solution]

Please see this link, a Tool from Steve Dark.

QlikView App - Generic Data Profiler

It's a great Tool to show the in depth information of your data.

In general, you can add this tool as a Sheet in your App. It will give you a good information around your data.

[alexdataiq]

As Thornofcrowns‌ points out, there are no data types in QV as they use a Dual format. You can read why here:

Data Types in QlikView‌

Regards

[rebelfox]

That's interesting.  There are however some fields with no 'Tags' entry.  Does the empty 'Tags' value indicate something?

[rebelfox]

WOW.  This is rather good.  Thanks.

[rebelfox]

Very useful thanks.