Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
The inline table looks fine, have you also issued the HidePrefix statement itself:
Set HidePrefix = '%';
- Steve
It is someting with my Qlikview.
In a new Qlikview everything works fine.
Thanks
Greetz,
Dirk
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.
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
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
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
Hi!
Look the attached example.
It works Thank you Felipe!