topic Use of HidePrefix in QlikView

Use of HidePrefix

Thu, 18 Dec 2014 09:17:09 GMT

Hi,

I recently was trying to understand system fields and that is when i came across Hideprefix/Hidesuffix statements.

When i set a symbol (%) with hideprefix i.e. SET hideprefix ='%' and use it for naming a field as %test, then %test is not displayed in current selection.

This is exactly as per the explanation in one of Qlik Discussion example on system fields

In order to understand whether hideprefix is a function or just another user-defined variable, i replaced it with user i.e. SET user='%'.

But still i cannot see %test in current selection. I have deleted hideprefix from Variable overview and also checked Show System Fields, but no luck.

Request someone to please answer how can i make filed %test visible again.

Also what is the significance of using hideprefix when associated values of the hidden field value can be seen?

Kind Regards,

Nupur

Re: Use of HidePrefix

Michiel_QV_Fan — Thu, 18 Dec 2014 09:22:01 GMT

Rename %test to test might do the trick.

Hide prefix is a way to hide your keys from selections. Or other fields that should not be selected for any reason.

Re: Use of HidePrefix

Peter_Cammaert — Thu, 18 Dec 2014 09:27:00 GMT

HIDEPREFIX and HIDESUFFIX are variables. The nature of variables is such that they stay set even if you don't actually initialize them anymore the next time you run your load script. But you can unset them by using the following ... SET

SET HIDEPREFIX=;

Re: Use of HidePrefix

sujeetsingh — Thu, 18 Dec 2014 09:27:22 GMT

Better way is to rename the field and try.

Re: Use of HidePrefix

jpenuliar — Thu, 18 Dec 2014 09:35:50 GMT

HidePrefix – hiding fields

a bit of explanation on this thread

Re: Use of HidePrefix

Thu, 18 Dec 2014 09:36:34 GMT

Hi Michiel,

Thank you for your quick response.

Re: Use of HidePrefix

Thu, 18 Dec 2014 09:52:09 GMT

Thank you all for quick responses.

Got much clear understanding now.

Kind regards,

Nupur