topic Expr to show specific values in list box in QlikView https://community.qlik.com/t5/QlikView/Expr-to-show-specific-values-in-list-box/m-p/632649#M1088525 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to show only specific values in my list box. I wrote the below expression but it shows nothing in the list box</P><P></P><P>=if(Type='Gross' and 'Net',Type)</P><P></P><P>I infact, want to show only 2 values ie Gross and Net in the Type list box(ie field Type).</P></BODY></HTML> Thu, 29 May 2014 13:41:47 GMT surajap123 2014-05-29T13:41:47Z Expr to show specific values in list box https://community.qlik.com/t5/QlikView/Expr-to-show-specific-values-in-list-box/m-p/632649#M1088525 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to show only specific values in my list box. I wrote the below expression but it shows nothing in the list box</P><P></P><P>=if(Type='Gross' and 'Net',Type)</P><P></P><P>I infact, want to show only 2 values ie Gross and Net in the Type list box(ie field Type).</P></BODY></HTML> Thu, 29 May 2014 13:41:47 GMT https://community.qlik.com/t5/QlikView/Expr-to-show-specific-values-in-list-box/m-p/632649#M1088525 surajap123 2014-05-29T13:41:47Z Re: Expr to show specific values in list box https://community.qlik.com/t5/QlikView/Expr-to-show-specific-values-in-list-box/m-p/632650#M1088526 <HTML><HEAD></HEAD><BODY><P>If(Type='Gross' or Type='Net,Type)</P></BODY></HTML> Thu, 29 May 2014 13:44:08 GMT https://community.qlik.com/t5/QlikView/Expr-to-show-specific-values-in-list-box/m-p/632650#M1088526 antoniotiman 2014-05-29T13:44:08Z Re: Expr to show specific values in list box https://community.qlik.com/t5/QlikView/Expr-to-show-specific-values-in-list-box/m-p/632651#M1088527 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P>=If(Type='Gross' or Type='Net')</P></BODY></HTML> Thu, 29 May 2014 13:51:00 GMT https://community.qlik.com/t5/QlikView/Expr-to-show-specific-values-in-list-box/m-p/632651#M1088527 Anonymous 2014-05-29T13:51:00Z Re: Expr to show specific values in list box https://community.qlik.com/t5/QlikView/Expr-to-show-specific-values-in-list-box/m-p/632652#M1088528 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=if(Match(Type,'Gross','Net'),Type)</SPAN></P></BODY></HTML> Fri, 30 May 2014 05:50:55 GMT https://community.qlik.com/t5/QlikView/Expr-to-show-specific-values-in-list-box/m-p/632652#M1088528 anbu1984 2014-05-30T05:50:55Z