# 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:

System fields

| Field | Description |
| --- | --- |
| [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/System_fields.htm)$Table | Displays all internal tables loaded<br>by the script. When a single table is selected,<br>an information symbol will activate in the caption area of the list box.<br>By clicking here, it is possible to view the table, if it comes from a file. |
| $Field | Displays the fields that are read<br>from the tables. By setting this list box to Show<br>Frequency in the List Box Properties: General<br>page, it is simple to detect key fields that occur in several internal<br>tables. |
| [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/System_fields.htm)$Fields | The numbers in this list box represent the<br>number of fields in different tables. |
| $FieldNo | This list box shows the position of the fields<br>in the tables. |
| [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/System_fields.htm)$Rows | This list box shows the number of rows in<br>the tables. |
| [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/System_fields.htm)$Info | If info tables have been included in the document,<br>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.