topic Re: Limiting what appears in list boxes in QlikView https://community.qlik.com/t5/QlikView/Limiting-what-appears-in-list-boxes/m-p/910145#M316037 <HTML><HEAD></HEAD><BODY><P>Perhaps this could help you</P></BODY></HTML> Tue, 04 Aug 2015 16:51:14 GMT maximiliano_vel 2015-08-04T16:51:14Z Limiting what appears in list boxes https://community.qlik.com/t5/QlikView/Limiting-what-appears-in-list-boxes/m-p/910143#M316035 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">I'm having some trouble limiting what appears in a list box and none of the suggestions I have found so far on here have worked. Essentially what I have is data for three different companies which I'm organizing a few different ways. For part of it, I have three separate sheets that detail sales information of each company separately. The list boxes on each page have options for Branch ID for all three companies and I would like to limit this to only showing Branch IDs relative to the company who's sheet it's on. I've been trying the editing the expression or using the conditional option, but neither seem to work. </SPAN></P><P></P><P></P><P><SPAN style="font-size: 12pt;">Thanks in advance!</SPAN></P></BODY></HTML> Tue, 04 Aug 2015 14:03:24 GMT https://community.qlik.com/t5/QlikView/Limiting-what-appears-in-list-boxes/m-p/910143#M316035 2015-08-04T14:03:24Z Re: Limiting what appears in list boxes https://community.qlik.com/t5/QlikView/Limiting-what-appears-in-list-boxes/m-p/910144#M316036 <HTML><HEAD></HEAD><BODY><P>Try an Expression, something like:</P><P></P><P>=if(Company = 'Company A',BranchID)</P></BODY></HTML> Tue, 04 Aug 2015 16:20:33 GMT https://community.qlik.com/t5/QlikView/Limiting-what-appears-in-list-boxes/m-p/910144#M316036 m_woolf 2015-08-04T16:20:33Z Re: Limiting what appears in list boxes https://community.qlik.com/t5/QlikView/Limiting-what-appears-in-list-boxes/m-p/910145#M316037 <HTML><HEAD></HEAD><BODY><P>Perhaps this could help you</P></BODY></HTML> Tue, 04 Aug 2015 16:51:14 GMT https://community.qlik.com/t5/QlikView/Limiting-what-appears-in-list-boxes/m-p/910145#M316037 maximiliano_vel 2015-08-04T16:51:14Z Re: Limiting what appears in list boxes https://community.qlik.com/t5/QlikView/Limiting-what-appears-in-list-boxes/m-p/910146#M316038 <HTML><HEAD></HEAD><BODY><P>I had to add brackets to Branch ID because my data title has a space but it worked perfectly! Thank you!</P></BODY></HTML> Tue, 04 Aug 2015 17:15:23 GMT https://community.qlik.com/t5/QlikView/Limiting-what-appears-in-list-boxes/m-p/910146#M316038 2015-08-04T17:15:23Z