Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set HidePrefix change the field name

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.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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.

View solution in original post

4 Replies
Chanty4u
MVP
MVP

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

swuehl
MVP
MVP

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.

Not applicable
Author

Could you provide or have any insights into this algorithm?

swuehl
MVP
MVP

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.