topic Field Types In A QlikView Document in QlikView

Field Types In A QlikView Document

rebelfox — Wed, 25 Nov 2020 16:16:04 GMT

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 )?.

Re: Field Types In A QlikView Document

Thu, 17 Mar 2016 15:57:28 GMT

Hi,

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

Thanks,

Itishree

Re: Field Types In A QlikView Document

ThornOfCrowns — Thu, 17 Mar 2016 16:07:26 GMT

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

Re: Field Types In A QlikView Document

Saravanan_Desingh — Thu, 17 Mar 2016 16:15:43 GMT

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.

Re: Field Types In A QlikView Document

alexdataiq — Thu, 17 Mar 2016 16:24:14 GMT

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

Re: Field Types In A QlikView Document

rebelfox — Fri, 18 Mar 2016 07:53:59 GMT

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

Re: Field Types In A QlikView Document

rebelfox — Fri, 18 Mar 2016 09:05:59 GMT

WOW. This is rather good. Thanks.

Re: Field Types In A QlikView Document

rebelfox — Fri, 18 Mar 2016 10:31:21 GMT

Very useful thanks.