System fields

In addition to the fields extracted from the data source, system fields are also produced by QlikView. These all begin with "$" and can be displayed in list boxes much like ordinary fields. System fields are typically created during script execution, are primarily used as an aid in document design.

Displaying System Fields

Perform the following steps:

  1. Right-click on the sheet and select System Fields.
  2. Check the Show System Fields box.

The system fields are now available as any other fields.

Available System Fields

The following system fields can be displayed:

$Table Displays all internal tables loaded by the script. When a single table is selected, an information symbol will activate in the caption area of the list box. By clicking here, it is possible to view the table, if it comes from a file.
$Field Displays the fields that are read from the tables. By setting this list box to Show Frequency in the List Box Properties: General page, it is simple to detect key fields that occur in several internal tables.
$Fields The numbers in this list box represent the number of fields in different tables.
$FieldNo This list box shows the position of the fields in the tables.
$Rows This list box shows the number of rows in the tables.
$Info If info tables have been included in the document, their names will be displayed here.

System Table

QlikView can automatically create a pivot table that makes use of the system fields.The table is called System Table and contains the two dimensions $Field and $Table and the expression only([$Field]). The system table is sorted according to frequency by default. The system table object is not available for the QlikView Server clients (AJAX and Plugin clients).

Creating a System Table

Perform the following steps:

  1. Right-click on the sheet and select New Sheet Object.
  2. Select System Table.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?