topic Hide fields in your data model with HidePrefix in QlikView

Hide fields in your data model with HidePrefix

stevedark — Wed, 29 Jun 2011 22:11:12 GMT

Hi there,

The HidePrefix statement allows you to hide fields that exist in your data model that you don't wish to be visible to users when they are building charts etc.

I have created a blog post describing the use of the statement here: Do you have something to hide?

- Steve

Hide fields in your data model with HidePrefix

Mon, 17 Oct 2011 14:24:11 GMT

And when i want to hide inline tables?

Do you know how that works?

example:

LOAD * INLINE

[

%Choices

Yes

];

I can't hide the fieldname choices

Greetz,

Dirk

Hide fields in your data model with HidePrefix

stevedark — Mon, 17 Oct 2011 19:49:29 GMT

The inline table looks fine, have you also issued the HidePrefix statement itself:

Set HidePrefix = '%';

- Steve

Hide fields in your data model with HidePrefix

Tue, 18 Oct 2011 06:52:36 GMT

It is someting with my Qlikview.

In a new Qlikview everything works fine.

Thanks

Greetz,

Dirk

Hide fields in your data model with HidePrefix

stevedark — Tue, 18 Oct 2011 18:43:35 GMT

Could it be the order in which you are issuing the HidePrefix and the Load in your script - or perhaps another HidePrefix already in your document?

Another thing I would try is explicitly putting the field name in the load:

LOAD

%Choices

;

INLINE [

%Choices

Yes

];

Not that this *should* make any difference.

Hide fields in your data model with HidePrefix

Wed, 19 Oct 2011 07:52:22 GMT

Steve,

The problem was indeed that there was another HidePrefix Statement in my code.

A googlemaps sollution in my qlikview used it allready

Thanks.

Greetz,

Dirk

Re: Hide fields in your data model with HidePrefix

hectorgarcia — Mon, 25 Nov 2013 13:18:46 GMT

the same happened ti me , i found another HidePrefix Statement in my code.

A googlemaps sollution in my qlikview used it already

thanks steve and dirk for your advise

Re: Hide fields in your data model with HidePrefix

Fri, 07 Mar 2014 03:05:39 GMT

Hi,

How do we rename a qualified field (eg: TableName.FieldName) to a hidden field?

I've tried few combinations but they still don't work:

a. "[FieldName] as [~FieldName]"

b. "[Fieldname] as ~FieldName

The field will still be available and visible for selection in the sheet. If it is not qualify ("FieldName"), then it works.

Thank you in advance

Re: Re: Hide fields in your data model with HidePrefix

felipe_dutra — Fri, 07 Mar 2014 03:53:09 GMT

Hi!

Look the attached example.

Re: Re: Hide fields in your data model with HidePrefix

Fri, 07 Mar 2014 04:44:51 GMT

It works Thank you Felipe!