Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
rebelfox
Creator
Creator

Field Types In A QlikView Document

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

1 Solution

Accepted Solutions
Saravanan_Desingh

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.

View solution in original post

7 Replies
Not applicable

Hi,

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


Capture.PNG


Thanks,

Itishree

ThornOfCrowns
Specialist II
Specialist II

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

Saravanan_Desingh

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
Partner - Creator III
Partner - Creator III

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
Creator
Creator
Author

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

rebelfox
Creator
Creator
Author

WOW.  This is rather good.  Thanks.

rebelfox
Creator
Creator
Author

Very useful thanks.