topic Re: Hide Fields in the Selection Box in QlikView https://community.qlik.com/t5/QlikView/Hide-Fields-in-the-Selection-Box/m-p/516877#M192959 <HTML><HEAD></HEAD><BODY><P>In the laod script, after the load statement from excel...</P></BODY></HTML> Thu, 06 Feb 2014 13:43:27 GMT 2014-02-06T13:43:27Z Hide Fields in the Selection Box https://community.qlik.com/t5/QlikView/Hide-Fields-in-the-Selection-Box/m-p/516872#M192954 <HTML><HEAD></HEAD><BODY><P>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 <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" />&nbsp; .. Any Ideas?</P><P></P><P>Thanks,</P><P></P><P>John</P></BODY></HTML> Mon, 02 Dec 2013 16:21:29 GMT https://community.qlik.com/t5/QlikView/Hide-Fields-in-the-Selection-Box/m-p/516872#M192954 2013-12-02T16:21:29Z Re: Hide Fields in the Selection Box https://community.qlik.com/t5/QlikView/Hide-Fields-in-the-Selection-Box/m-p/516873#M192955 <HTML><HEAD></HEAD><BODY><P>I have the same question...</P></BODY></HTML> Thu, 06 Feb 2014 10:19:08 GMT https://community.qlik.com/t5/QlikView/Hide-Fields-in-the-Selection-Box/m-p/516873#M192955 2014-02-06T10:19:08Z Re: Hide Fields in the Selection Box https://community.qlik.com/t5/QlikView/Hide-Fields-in-the-Selection-Box/m-p/516874#M192956 <HTML><HEAD></HEAD><BODY><P>Add a tag to your field in the script :</P><P></P><P>Tag Fields [YourField] with $hidden;</P><P></P><P></P><P>Michael</P></BODY></HTML> Thu, 06 Feb 2014 10:21:40 GMT https://community.qlik.com/t5/QlikView/Hide-Fields-in-the-Selection-Box/m-p/516874#M192956 agilos_mla 2014-02-06T10:21:40Z Re: Hide Fields in the Selection Box https://community.qlik.com/t5/QlikView/Hide-Fields-in-the-Selection-Box/m-p/516875#M192957 <HTML><HEAD></HEAD><BODY><P>creates two fields with the same content, one hidden one visible, and use these in different tabs</P></BODY></HTML> Thu, 06 Feb 2014 10:23:36 GMT https://community.qlik.com/t5/QlikView/Hide-Fields-in-the-Selection-Box/m-p/516875#M192957 2014-02-06T10:23:36Z Re: Hide Fields in the Selection Box https://community.qlik.com/t5/QlikView/Hide-Fields-in-the-Selection-Box/m-p/516876#M192958 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply.</P><P>I import my data from Excel Files, where do I write $hidden ?</P><P></P><P>Lucas</P></BODY></HTML> Thu, 06 Feb 2014 12:23:33 GMT https://community.qlik.com/t5/QlikView/Hide-Fields-in-the-Selection-Box/m-p/516876#M192958 2014-02-06T12:23:33Z Re: Hide Fields in the Selection Box https://community.qlik.com/t5/QlikView/Hide-Fields-in-the-Selection-Box/m-p/516877#M192959 <HTML><HEAD></HEAD><BODY><P>In the laod script, after the load statement from excel...</P></BODY></HTML> Thu, 06 Feb 2014 13:43:27 GMT https://community.qlik.com/t5/QlikView/Hide-Fields-in-the-Selection-Box/m-p/516877#M192959 2014-02-06T13:43:27Z