Hide fields in your data model with HidePrefix

[stevedark]

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

[#2]

And when i want to hide inline tables?

Do you know how that works?

example:

LOAD * INLINE         

[

     %Choices

     Yes

     No

];

I can't hide the fieldname choices

Greetz,

Dirk

[stevedark]

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

Set HidePrefix = '%';

- Steve

[#4]

It is someting with my Qlikview.

In a new Qlikview everything works fine.

Thanks

Greetz,

Dirk

[stevedark]

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

No

];

Not that this *should* make any difference.

[#6]

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

[hectorgarcia]

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

[#8]

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

[felipe_dutra]

Hi!

Look the attached example.

[#10]

It works    Thank you Felipe!