Field tags
Field tags provide the possibility of adding metadata to the fields in your data model. There are two different types of field tags:
-
System field tags
System field tags are generated automatically when the script is executed and data is loaded. Some of the tags can be manipulated in the script. System tags are always preceded by a $ sign.
-
Custom field tags
You can add custom tags to fields in the data load script, using the Tag statement. Custom tags may not use the same name as any system tag.
See: Tag
See: Untag
System field tags
The following system field tags are generated at the end of script execution.
Tag | Description | Can be manipulated in the script |
---|---|---|
$system |
System field that is generated by Qlik Sense during script execution. See: System fields |
No |
$key | Key field providing a link between two or more tables. | No |
$keypart | The field is part of one or more synthetic keys. | No |
$syn |
Synthetic key See: Synthetic keys |
No |
$hidden |
Hidden field, that is, it is not displayed in any field selection list when creating visualizations, dimensions or measures. You can still use hidden fields in expressions, but you need to type the field name. You can use the HidePrefix and HideSuffix system variables to set which fields to hide. See: HidePrefix See: HideSuffix |
Yes |
$numeric | All (non-NULL) values in the field are numeric. | Yes |
$integer | All (non-NULL) values in the field are integers. | Yes |
$text | No values in the field are numeric. | Yes |
$ascii | Field values contain only standard ASCII characters. | Yes |
$date | All (non-NULL) values in the field can be interpreted as dates (integers). | Yes |
$timestamp | All (non-NULL) values in the field can be interpreted as time stamps. | Yes |
Learn more
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!