topic Set HidePrefix change the field name in QlikView

Set HidePrefix change the field name

Mon, 28 Mar 2016 16:59:23 GMT

Hello,

Just looking for some clarification, if I SET hideprefix = '%'

and alias all my fields (Ex. %FieldName1, %FieldName2) this will change the actual field throughout the document correct (e.g FieldName1 will no longer work in any table or chart it currently resides in, it will have to be changed to %FieldName1). Can anyone provide some clarification.

Re: Set HidePrefix change the field name

Chanty4u — Mon, 28 Mar 2016 17:01:42 GMT

hi,

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.

Note:It will not change

Re: Set HidePrefix change the field name

swuehl — Mon, 28 Mar 2016 17:03:36 GMT

There is somekind of algorithm that tries to detect a single change of a field name and tries to correct the use in expressions / dimensions accordingly. This does not work when changing multiple field names at once.

Re: Set HidePrefix change the field name

Mon, 28 Mar 2016 17:59:51 GMT

Could you provide or have any insights into this algorithm?

Re: Set HidePrefix change the field name

swuehl — Mon, 28 Mar 2016 18:05:31 GMT

I was talking about a built-in algorithm.

Just create a data model, reload, create a list box from one field. Rename this field in the script. Reload.