In QlikView v10 there are more choices for setting up Meta Data tags in the QlikView interface and the script. I will walk through a few different examples of the available features below:
When using the chart wizard there is a new Expression Comment box within the Expressions tab. Here you can enter comments or select meta data from a data source to tag some basic commentary about a particular expression.
|Comment Field Highlighted in Yellow|
When you view the Document Properties (Tables Tab) in QlikVIew 10 there is a new option ('Edit Tags') when you highlight a field with the field list.
|Edit Tags within Document Properties/Tables Tab|
There is no limit to the number of tags that can be added here. You will also noticed that there some existing Meta Data provided by QlikView on the type of field. In this case we can see that the field 'G' is numeric and is of the type integer.
|Table Viewer - Mouse Over Field|
Adding Tags in the Script:
Meta Tags can be added via the script using a Mapping Load and the Tag Function. Using the same example above I have an external source that has the field names and some meta data descriptions. Using the script sample below I can load the Meta Data using a Mapping Load in conjunction with the Tag command:
|Use of Mapping Load and the TAG Function|
The Tag function provides a way of assigning tags to a field. Field names not present in the document are ignored. If conflicting occurrences of a field or tag name are found, the last value is used.
A field tagged with dimension will be displayed at the top of all field selection controls in QlikView except in the Edit Expression dialog.
A field tagged with measure will be displayed at the top of all field selection controls in the Edit Expression dialog. Examples of where these tags display are below:
|Select Fields Dialog|
These new features are welcome additions to QlikView in helping you better track Meta Data in your QlikView applications. Your users will appreciate the added value of having Meta Data descriptors when trying to enhance their QlikView applications.