Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide Fields in the Selection Box

On some sheets I have Fields built into expressions. I'd like to have these fields excluded from the Selection Box to avoid confusion since they don't affect the charts.. However, in other sheets I want to allow the user to select these fields. How can I do this? Using HidePrefix spans all sheets which I don't want. I suppse I could use Alternate States but would rather not create all the extra work   .. Any Ideas?

Thanks,

John

Labels (1)
5 Replies
Not applicable
Author

I have the same question...

agilos_mla
Partner - Creator III
Partner - Creator III

Add a tag to your field in the script :

Tag Fields [YourField] with $hidden;

Michael

Not applicable
Author

creates two fields with the same content, one hidden one visible, and use these in different tabs

Not applicable
Author

Thanks for the reply.

I import my data from Excel Files, where do I write $hidden ?

Lucas

Not applicable
Author

In the laod script, after the load statement from excel...