Mastering Qlik Sense

HidePrefix and HideSuffix

These two variables are used to hide fields from the selection bar. Whenever a field starts or ends with the character set in these two user-defined variables, the fields will be hidden the same way as the system fields are. If values are selected in these fields, they won't be shown in the selection bar. However, they can still be used when creating front-end expressions.

The following block of code shows an example of how to set these variables:

SET HidePrefix = '%';SET HideSuffix = '_';

In this example, all the fields in our model that start with the character % will be hidden. This is a great example of when we work with our table keys. Table keys are usually used to join tables, however, they are hardly used ...