topic Re: HidePrefix in QlikView

HidePrefix

NavinReddy — Fri, 14 Mar 2014 14:18:32 GMT

Dear All,

could some one help me

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

Thanks In Advance

Niranjan

Bill_Britt — Fri, 14 Mar 2014 14:25:13 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.

Bill

markodonovan — Fri, 14 Mar 2014 14:26:43 GMT

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

stabben23 — Fri, 14 Mar 2014 14:29:19 GMT

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 — Fri, 14 Mar 2014 14:35:12 GMT

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

mike

www.fortunecookiebi.com

NavinReddy — Fri, 14 Mar 2014 15:05:52 GMT

Thanks so much all