Synopsis
You can add metadata to the fields in your data model using field tags.
Systems tags are generated during the script reload, and they precede $.
A developer found multiple hidden fields in the data model even though he did not do so while writing the script.
Perhaps a bug; I am not sure.
In this article, I wanted to show a simple way to list all of the hidden tags and untag them using a mapping table.
Let’s get started!
Qlik Sense Dev Hub
You can only view field tags in the data model viewer. It is easy to verify if the field has a $hidden tag and add untag field syntax in your script to remove $hidden tag, but that’s a tedious and time-consuming approach if you have many fields to untag.
Enter Qlik Sense Dev Hub.
Start by searching for the method to list fields with tags in your application.
I found the method: GetMatchingFields
The next step is to open Engine API Explorer in the Dev Hub and connect to the engine.
Select your app from the drop-down list.
Select GetMatchingFields method from the Methods drop-down.
Add $hidden as a qTags parameter and execute the request.
You will see a JSON response as depicted below
Convert JSON to CSV
Next, copy the list and paste it into one of the free online tools to generate a CSV list. We will use this list to create a mapping table.
Use Mapping Table to Untag Fields
The last step is to use this list of fields to create a mapping table and modify your script.
tagsmap:
mapping load
*,
‘$hidden’ as fieldTag
;
load * inline [
fieldName
Customers.CustomerCity_GeoInfo
Customers.CustomerCountry_GeoInfo
Employees.City_GeoInfo
Employees.Country_GeoInfo
Facts.ShipCity_GeoInfo
Facts.ShipCountry_GeoInfo
Products.dataroot/Suppliers.City_GeoInfo
Products.dataroot/Suppliers.Country_GeoInfo
]
;
untag Fields using tagsmap;
Summary:
Qlik Sense Dev Hub provides a set of APIs that you can leverage as a Qlik Sense developer to extend functionality by not only allowing you to create mashups and extensions but also to explore various methods using the Engine API explorer.
We offer a comprehensive course with a deep dive approach to have you get started with the Qlik Sense Dev Hub.
Join our academy, and let’s help you take your Qlik skills to the next level!
