HidePrefix in QlikSense

Hello All...!!!

Today, we are going to discuss about Hide Prefix.

Most of us must have used the variable HidePrefix variable in QlikView, where we can set the text string to variable and all field names beginning with this text string will be hidden in the same manner as the system fields. This is a user-defined variable.

But, can we also achieve the same in QlikSense.

So here is a catch, we can achieve the same to some extent.

In order to restrict fields from the Selection Tool as well we will need to use the

SET HidePrefix = '_'; // for any field name that begins with _ will be hidden

or

SET HideSuffix = '_'; // for any field name that ends with _ will be hidden

and this should make the field invisible to the Selection Tool. 

So, now suppose, we have a table with values as –

And I would like to hide F2 and F3, so I rename the same and set the hideprefix and hidesuffix to- 

 I will not be able to see the fields F2 and F3 in the Selection Tool –

But when I say, to some extent, is because, if there is any user who knows the exact name of the field, he can still type it and use it from a filter pane.

That’s it for this blog post. Stay tuned, for more articles like this…!!!