topic Re: How to have selective data in a List Box in QlikView https://community.qlik.com/t5/QlikView/How-to-have-selective-data-in-a-List-Box/m-p/1337252#M412373 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><STRONG>=If(Match([Item.Full Name]), 'SH318CKASS','SH318FASS','SH318RVASS','SH318SKASS',[Item.Full Name])</STRONG></P></BODY></HTML> Wed, 19 Jul 2017 15:40:13 GMT Anil_Babu_Samineni 2017-07-19T15:40:13Z How to have selective data in a List Box https://community.qlik.com/t5/QlikView/How-to-have-selective-data-in-a-List-Box/m-p/1337251#M412372 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I am using Quickbooks advanced reporting which is powered by Qlikview, I am trying to use a listbox [Item.Full Name].</P><P></P><P>Yet we have many items that we do not want on the list box. is there a way i can select just the items i want to be shown in the listbox?</P><P></P><P>This is the expression I have entered into the List Box Field. </P><P></P><P>=If([Item.Full Name]='SH318CKASS','SH318FASS','SH318RVASS','SH318SKASS',[Item.Full Name])</P><P></P><P>This returns an Error. </P><P></P><P>Thank you very much,. </P></BODY></HTML> Wed, 19 Jul 2017 14:41:24 GMT https://community.qlik.com/t5/QlikView/How-to-have-selective-data-in-a-List-Box/m-p/1337251#M412372 2017-07-19T14:41:24Z Re: How to have selective data in a List Box https://community.qlik.com/t5/QlikView/How-to-have-selective-data-in-a-List-Box/m-p/1337252#M412373 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><STRONG>=If(Match([Item.Full Name]), 'SH318CKASS','SH318FASS','SH318RVASS','SH318SKASS',[Item.Full Name])</STRONG></P></BODY></HTML> Wed, 19 Jul 2017 15:40:13 GMT https://community.qlik.com/t5/QlikView/How-to-have-selective-data-in-a-List-Box/m-p/1337252#M412373 Anil_Babu_Samineni 2017-07-19T15:40:13Z Re: How to have selective data in a List Box https://community.qlik.com/t5/QlikView/How-to-have-selective-data-in-a-List-Box/m-p/1337253#M412374 <HTML><HEAD></HEAD><BODY><P>Thank you very much</P></BODY></HTML> Wed, 19 Jul 2017 15:42:34 GMT https://community.qlik.com/t5/QlikView/How-to-have-selective-data-in-a-List-Box/m-p/1337253#M412374 2017-07-19T15:42:34Z Re: How to have selective data in a List Box https://community.qlik.com/t5/QlikView/How-to-have-selective-data-in-a-List-Box/m-p/1337254#M412375 <HTML><HEAD></HEAD><BODY><P>Just a small correction Anil, Close the bracket for Match after last value like</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">= If(Match( [Item.Full Name] , 'SH318CKASS','SH318FASS','SH318RVASS','SH318SKASS' <SPAN style="color: #ff6600;">)</SPAN> , [Item.Full Name] )</STRONG></P></BODY></HTML> Wed, 19 Jul 2017 15:47:06 GMT https://community.qlik.com/t5/QlikView/How-to-have-selective-data-in-a-List-Box/m-p/1337254#M412375 vishsaggi 2017-07-19T15:47:06Z Re: How to have selective data in a List Box https://community.qlik.com/t5/QlikView/How-to-have-selective-data-in-a-List-Box/m-p/1337255#M412376 <HTML><HEAD></HEAD><BODY><P>Awesome, Please close this thread by flag correct answer</P><P></P><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P></BODY></HTML> Wed, 19 Jul 2017 15:51:57 GMT https://community.qlik.com/t5/QlikView/How-to-have-selective-data-in-a-List-Box/m-p/1337255#M412376 Anil_Babu_Samineni 2017-07-19T15:51:57Z