Table Viewer

The Table Viewer dialog is opened when choosing Table Viewer from the File menu or pressing Ctrl+T.

This dialog is used to display the data table structure of the current QlikView document. Tables are shown as boxes with a list of the fields they contain. Connector lines between the boxes show the associations. Where more than two lines meet there are connector points in the form of small dots.

The tables, the connector points and also all points where the connectors bend can be moved by means of mouse drag and drop (see below). When re-arranging the layout like this, the changes will be saved with the document unless the dialog is exited with Cancel.

There are two views available, the layouts of which are stored separately. The two views are:

• The Internal Table View is the default view. It shows the data tables as QlikView stores them. Composite synthetic keys are formed in tables that share more than one field. Synthetic tables are used to link them. This view offers the best understanding of the QlikView logic and also provides a very clean layout where each pair of tables has a maximum of one connector between them.

  

• The Source Table View shows data tables as QlikView reads them. Here there are no synthetic fields or synthetic tables. Composite keys are represented by multiple connectors between tables.

  

When hovering with the cursor above one of the fields in a table, a tool tip pops up with information about the content of this field:

• Information density is the number of records that have values (i.e. not NULL) in this field as compared to the total number of records in the table.

• Subset ratio is the number of distinct values of this field found in this table as compared to the total number of distinct values of this field (that is other tables as well).
• Table comments are displayed in the tool tip.
• Field comments are displayed in the tool tip.
• Tags that are added in the script or in Document Properties: Tables page, including system tags, are displayed in the tool tip.

The following actions can be performed in the table layouts:

• Click on Table Caption: Highlights the table, all tables with direct logical associations with that table and the connections between them.
• Point at Table Caption and Drag: Moves the table in the layout.
• Hover Over Table Caption: Shows pop-up info about table.
• Click on Field in Table: Highlights the table, the field, all tables containing that field and the connections between them.
• Hover over Field in Table: Shows pop-up info about field.
• Right-click in a Table: Click on Preview to see a dialog of sample records from the loaded data.
• Point at Connector Point or Connector Bend and Drag: Moves the connector point in the layout.
• Right-click on Connector Point or Connector Bend: Moves the connector point back to automatic positioning.
• Click on Layout Background: Cancels all highlighting of tables, fields and connectors.

 

The following commands are available in the dialog toolbar and buttons:

• Export Image: Opens a file browser dialog making it possible to save the current table view as a bitmap or png image to a file on disc.
• Export Structure: By pressing this button it is possible to export the table structure of the document to a set of text files.
  These text files, one for the tables (filename.Tables.tab), one for the fields (filename.Fields.tab) and one for mapping in between (filename.Mappings.tab) can easily be read back into QlikView for further analysis with the full power of the QlikView logic. A dialog will appear where the target folder for the export can be chosen. The default is to put the files in the same folder as the QlikView document.
• Print Image: Opens the Print dialog from which it is possible to print the current table view. Equivalent to pressing Ctrl+P.
• Copy Image: Copies the current table view as an image to clipboard. Equivalent to pressing Ctrl+C.
• Auto Layout: Re-arranges the tables in the current view.
• Zoom: The zoom factor of the current view can be set in this drop-down box.
• View: Choose between Internal Table View and Source Table View (see above).