topic Listbox in QlikView https://community.qlik.com/t5/QlikView/Listbox/m-p/34516#M606114 <HTML><HEAD></HEAD><BODY><P>HI i have a field name [tp IASS] which has value if&nbsp; aa,ab,ac,ad ,&nbsp; i only want to show Aa,ac,and,ad.&nbsp; in listbox</P></BODY></HTML> Tue, 15 May 2018 15:09:08 GMT everest226 2018-05-15T15:09:08Z Listbox https://community.qlik.com/t5/QlikView/Listbox/m-p/34516#M606114 <HTML><HEAD></HEAD><BODY><P>HI i have a field name [tp IASS] which has value if&nbsp; aa,ab,ac,ad ,&nbsp; i only want to show Aa,ac,and,ad.&nbsp; in listbox</P></BODY></HTML> Tue, 15 May 2018 15:09:08 GMT https://community.qlik.com/t5/QlikView/Listbox/m-p/34516#M606114 everest226 2018-05-15T15:09:08Z Re: Listbox https://community.qlik.com/t5/QlikView/Listbox/m-p/34517#M606115 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try this:</P><P></P><P>=if(match(field,'value1','value2','value3',..'valuex'), field)</P></BODY></HTML> Tue, 15 May 2018 15:10:30 GMT https://community.qlik.com/t5/QlikView/Listbox/m-p/34517#M606115 YoussefBelloum 2018-05-15T15:10:30Z Re: Listbox https://community.qlik.com/t5/QlikView/Listbox/m-p/34518#M606116 <HTML><HEAD></HEAD><BODY><P>Try like </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">= IF(Not Match([tp IASS], 'ab'), <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> [tp IASS])</SPAN></SPAN></P></BODY></HTML> Tue, 15 May 2018 15:16:01 GMT https://community.qlik.com/t5/QlikView/Listbox/m-p/34518#M606116 vishsaggi 2018-05-15T15:16:01Z