Qlik Sense Dev Hub

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!

If you enjoyed this article, get email updates (it’s free).

* indicates required
About the author

Leave a Reply