Discussion Board for collaboration on QlikView Scripting.
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?
And when i want to hide inline tables?
Do you know how that works?
LOAD * INLINE
I can't hide the fieldname choices
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:
Not that this *should* make any difference.
The problem was indeed that there was another HidePrefix Statement in my code.
A googlemaps sollution in my qlikview used it allready
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
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