topic Re: How to hide/exclude values from field in a listbox in QlikView https://community.qlik.com/t5/QlikView/How-to-hide-exclude-values-from-field-in-a-listbox/m-p/1370050#M833509 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 14 Jun 2017 14:32:12 GMT sunny_talwar 2017-06-14T14:32:12Z How to hide/exclude values from field in a listbox https://community.qlik.com/t5/QlikView/How-to-hide-exclude-values-from-field-in-a-listbox/m-p/1370046#M833505 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P></P><P>I want to hide/exclude certain values from a list box</P><P></P><P>What expression can i use to only show hoodies and jumpers?</P><P></P><P style="text-align: center;"><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P style="text-align: center;"><SPAN style="font-size: 10pt;">Field:&nbsp;&nbsp; </SPAN><SPAN style="text-decoration: underline;"> Clothing</SPAN></P><P style="text-align: center;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; T-shirts</P><P style="text-align: center;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jeans</P><P style="text-align: center;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Trainers</P><P style="text-align: center;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hoodies</P><P style="text-align: center;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jumpers</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-hide-exclude-values-from-field-in-a-listbox/m-p/1370046#M833505 aaronnayan 2020-11-25T16:16:04Z Re: How to hide/exclude values from field in a listbox https://community.qlik.com/t5/QlikView/How-to-hide-exclude-values-from-field-in-a-listbox/m-p/1370047#M833506 <HTML><HEAD></HEAD><BODY><P>You can use Expression like</P><P><STRONG>If(Match(Clothing, 'hoodies','jumpers'), Clothing)</STRONG></P></BODY></HTML> Wed, 14 Jun 2017 14:21:58 GMT https://community.qlik.com/t5/QlikView/How-to-hide-exclude-values-from-field-in-a-listbox/m-p/1370047#M833506 Anil_Babu_Samineni 2017-06-14T14:21:58Z Re: How to hide/exclude values from field in a listbox https://community.qlik.com/t5/QlikView/How-to-hide-exclude-values-from-field-in-a-listbox/m-p/1370048#M833507 <HTML><HEAD></HEAD><BODY><P>Another option</P><P><STRONG>Aggr(Only({1&lt;Clothing = {'Hoodies','Jumpers'}&gt;} Clothing), Clothing)</STRONG></P></BODY></HTML> Wed, 14 Jun 2017 14:23:51 GMT https://community.qlik.com/t5/QlikView/How-to-hide-exclude-values-from-field-in-a-listbox/m-p/1370048#M833507 sunny_talwar 2017-06-14T14:23:51Z Re: How to hide/exclude values from field in a listbox https://community.qlik.com/t5/QlikView/How-to-hide-exclude-values-from-field-in-a-listbox/m-p/1370049#M833508 <HTML><HEAD></HEAD><BODY><P>I like your nature because you always come up with different approach. Thanks Bhaiah</P></BODY></HTML> Wed, 14 Jun 2017 14:31:32 GMT https://community.qlik.com/t5/QlikView/How-to-hide-exclude-values-from-field-in-a-listbox/m-p/1370049#M833508 Anil_Babu_Samineni 2017-06-14T14:31:32Z Re: How to hide/exclude values from field in a listbox https://community.qlik.com/t5/QlikView/How-to-hide-exclude-values-from-field-in-a-listbox/m-p/1370050#M833509 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 14 Jun 2017 14:32:12 GMT https://community.qlik.com/t5/QlikView/How-to-hide-exclude-values-from-field-in-a-listbox/m-p/1370050#M833509 sunny_talwar 2017-06-14T14:32:12Z