Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

HidePrefix

Dear All,

could some one help me

why we are using   Hideprefix = ' - ' ;
please guide me         

Thanks In Advance

Niranjan

1 Solution

Accepted Solutions
Bill_Britt
Former Employee
Former Employee

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.


Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

View solution in original post

5 Replies
Bill_Britt
Former Employee
Former Employee

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.


Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
markodonovan
Specialist
Specialist

Hi Niru,

The HidePrefix option will hide any fields that start with this character.

Most of the time I use this will key fields that are not required in the UI.

As a test, create a new document with

LOAD 'test' as [-tester]

AUTOGENERATE(1);

Reload and you will see the -tester field.

Add the following line to your loadscript, reload and the field -tester will now be hidden.

HidePrefix = '-';

Thanks

Mark

http://www.techstuffy.com

stabben23
Partner - Master
Partner - Master

Hi Niru,

The reason is also that you shouldent use these fields in calculations and dimensions.

So if you use '_' as a prefix on your keys it will be Hide.

mikecrengland
Creator III
Creator III

For me, it's also important that these fields don't show in the Current Selections object.

mike

www.fortunecookiebi.com

NavinReddy
Creator II
Creator II
Author

Thanks so much all