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:
- Right-click on the sheet and select System Fields.
- 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 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:
- Right-click on the sheet and select New Sheet Object.
- Select System Table.