Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

stevedark
Not applicable

Hide fields in your data model with HidePrefix

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

9 Replies
Not applicable

Hide fields in your data model with HidePrefix

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
Not applicable

Hide fields in your data model with HidePrefix

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

Set HidePrefix = '%';

- Steve

Not applicable

Hide fields in your data model with HidePrefix

It is someting with my Qlikview.

In a new Qlikview everything works fine.

Thanks

Greetz,

Dirk

stevedark
Not applicable

Hide fields in your data model with HidePrefix

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.

Not applicable

Hide fields in your data model with HidePrefix

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
Not applicable

Re: Hide fields in your data model with HidePrefix

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

Not applicable

Re: Hide fields in your data model with HidePrefix

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
Not applicable

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

Hi!

Look the attached example.

Not applicable

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

It works    Thank you Felipe!