topic Need Help on restricting selection box value in QlikView https://community.qlik.com/t5/QlikView/Need-Help-on-restricting-selection-box-value/m-p/1134558#M520512 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Hi All ,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">How to hide values in a&nbsp; Drop down selection based on another column, </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">I mean I have a Multi box, where I have kept my selections, I need to hide Employee ID values based on the another selection when EMPL_Status = 'T'. How can I achieve this ? Any idea. Please help me on this !</SPAN></P></BODY></HTML> Thu, 01 Sep 2016 22:02:35 GMT 2016-09-01T22:02:35Z Need Help on restricting selection box value https://community.qlik.com/t5/QlikView/Need-Help-on-restricting-selection-box-value/m-p/1134558#M520512 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Hi All ,</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">How to hide values in a&nbsp; Drop down selection based on another column, </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">I mean I have a Multi box, where I have kept my selections, I need to hide Employee ID values based on the another selection when EMPL_Status = 'T'. How can I achieve this ? Any idea. Please help me on this !</SPAN></P></BODY></HTML> Thu, 01 Sep 2016 22:02:35 GMT https://community.qlik.com/t5/QlikView/Need-Help-on-restricting-selection-box-value/m-p/1134558#M520512 2016-09-01T22:02:35Z Re: Need Help on restricting selection box value https://community.qlik.com/t5/QlikView/Need-Help-on-restricting-selection-box-value/m-p/1134559#M520513 <HTML><HEAD></HEAD><BODY><P class=""><SPAN style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);">May be an expression...</SPAN></P><P class=""><SPAN style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><BR /></SPAN></P><P class=""><SPAN style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);">Aggr(Only({&lt;EMPL_Status -= {'T'}&gt;} [Employee ID]), [Employee ID])</SPAN></P><P class=""><BR /></P></BODY></HTML> Thu, 01 Sep 2016 23:48:20 GMT https://community.qlik.com/t5/QlikView/Need-Help-on-restricting-selection-box-value/m-p/1134559#M520513 sunny_talwar 2016-09-01T23:48:20Z