topic Re: HidePrefix in QlikView

HidePrefix

marco_puccetti — Thu, 18 Jun 2015 14:55:23 GMT

Hello, i've read something about the Hideprefix command, but i need further and more detailed informations about it.

Can you explain me the usage, the meaning of the command and when it is generally used?

Thanks

Marco

Re: HidePrefix

alexandros17 — Thu, 18 Jun 2015 15:00:39 GMT

With the command hideprefix you can hide a field that begin with the prefix you have choosen.

You can use this behaviour to hide fields that you have to manage but that you do not want to be seen by a final user

Re: HidePrefix

PabloOrtiz — Thu, 18 Jun 2015 15:02:20 GMT

From de qlik help.

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.

Re: HidePrefix

sunny_talwar — Thu, 18 Jun 2015 15:02:32 GMT

HidePrefix is usually used in the script to tag a certain field to behave like System Fields. The benefit is that it doesn't show up in the Current Selection box. So if you have a business case where you don't want to show your users a selection in a particular field you can use HidePrefix.

SET HidePrefix = '~';

LOAD Field1,

Field2 as [~Field2],

...

FROM...

HTH

Best,

Sunny

Re: HidePrefix

marco_puccetti — Thu, 18 Jun 2015 15:06:12 GMT

Thanks

Marco

Re: HidePrefix

alexandros17 — Thu, 18 Jun 2015 15:08:10 GMT

Hi Marco,

if you think the discussion is closed please mark a reply as useful or exact