Use of prefix and suffix

[qlikviewwizard]

Hi all,

Could anyone provide the use o prefix and suffix in data model design or front end.

Here is the examples.

SET HidePrefix = '_';

SET HideSuffix = '%';

Thanks in advance.

[sunny_talwar]

One important use: when you use HidePrefix you can hide that particular field from the current selection box on the front end of the application. This can be very useful in cases you are giving a demo of the application to somebody and doesn't want the user to see value selections for a particular field.

Best,

Sunny

[jagan · Accepted solution]

Hi,

From Qlikview help file

HidePrefix

All field names beginning with this text string will be hidden in the same manner as the system fields. A user-defined variable.

Example:

set HidePrefix='_' ;

If this statement is used, the field names beginning with an underscore will not be shown in the field name lists when the system fields are hidden.

HideSuffix

All field names ending with this text string will be hidden in the same manner as the system fields. A user-defined variable.

Example:

set HideSuffix='%';

If this statement is used, the field names ending with a percentage sign will not be shown in the field name lists when the system fields are hidden.

Generally this keywords are used to set the hidden fields in the field name lists, to view this fields in the list you need to enable the Show System Fields option.

For example:

set HidePrefix='_' ;

Assume that you have a field called _Key, this field is hidden in field list if you disable Show System fields option, if you want to see this then you have to enable the Show System fields option.

Hope this helps you.

Regards,

Jagan.