Document Properties - Tables in QliView

This article provides an introduction to Tables in QlikView applications.

Document properties of QlikView document

There are various document properties of QlikView documents. Then go to Settings -> Document properties.

property

Now I introduce "What are Tables in QlikView document properties.".

table

Introduction to Tables

Basically, a table is a collection of records in the form of rows and columns. A document properties table contains the following information.

Name: It defines the name of the internal table.

Loosely Coupled: If the alternative is checked, then the table is loosely coupled. It is possible to deliberately set this alternative for a table here.

# Records: The number of records (rows) of the table.

# Fields: The number of fields (columns) of the table.

# Keys: The number of key (connecting) fields (columns) of the table.

Comment: The comment can be used to display the comments read from the data source and the comment field.

You can then see the fields list at the bottom of the page. It shows all fields of the QlikView document, or if any internal table has been selected in the list above then it is the fields of that  internal table. The columns of the fields are as follows.

#: It defines the internal number of the field. The numbers are started from 0 to 5 in other words used by the QlikView system fields. By default it is not displayed in this list.

Name: This displays the name of the field.

Dimensions: Mark the check box to the right of the field name to add the system tag $dimension to the field. This tag denotes a field recommended for use in chart dimensions, list boxes and so on. A field tagged with a dimension that will be displayed at the top of all field selection controls in QlikView except in the Edit Expression.

Measures: This field can be used to mark the check box to the right of the field name to add the system tag $measure to the field.. This tag denotes a field recommended for use in expressions. A field tagged with measure will be displayed at the top of all field selection controls in the Edit Expression.

Tags: The tag displays the field tags and $ denotes a system tag.

Comment: The comment always displays the comments. It reads data from the data source and an indicator for any special status of the field, such as Semantic, AndMode, AlwaysOneSelected, Info, Locked or Hidden.

# Tables: The number of tables in which the field occurs.

# Values: The total number of field values, disregarding selections. This information is not available for key (connecting) fields.

# Distinct: The total number of distinct field values, disregarding selections.

Type: Displays an indicator for any special status of the field, such as Semantic, AndMode, AlwaysOneSelected, Locked or Hidden.

Edit Tags: When we click on the edit tags, then it opens a dialog where it is possible to add and remove tags. System tags cannot be removed here. Tags added may not be given a name occupied by a system tag.

Export Structure: By pressing this button it is possible to export the table structure of the document to a set of text files.

Tag Clean-Up: This button can be used to clean up any tags that might be left after a field has been removed from the QlikView document.

Summary

This article provided an introduction to tables in QlikView and describes what tables are in document properties.

Up Next
    Ebook Download
    View all
    Learn
    View all