topic Re: MultiBox Excluded values in QlikView https://community.qlik.com/t5/QlikView/MultiBox-Excluded-values/m-p/746522#M1033971 <HTML><HEAD></HEAD><BODY><P>Thank You for your help</P></BODY></HTML> Thu, 22 Jan 2015 10:56:50 GMT 2015-01-22T10:56:50Z MultiBox Excluded values https://community.qlik.com/t5/QlikView/MultiBox-Excluded-values/m-p/746517#M1033962 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>i have a multibox in my layout like YEAR, MONTH</P><P></P><P>under YEAR having 2013 &amp; 2014.</P><P>MONTH for 2013 year i have limited months only and 2014 i have Jan to Dec.</P><P></P><P>my issue is if i selected 2013 in multibox YEAR field, i want to display only 2013 included values.</P><P></P><P>how can i do this please Help me</P><P></P><P>Kindly Regards</P></BODY></HTML> Thu, 22 Jan 2015 06:47:55 GMT https://community.qlik.com/t5/QlikView/MultiBox-Excluded-values/m-p/746517#M1033962 2015-01-22T06:47:55Z Re: MultiBox Excluded values https://community.qlik.com/t5/QlikView/MultiBox-Excluded-values/m-p/746518#M1033964 <HTML><HEAD></HEAD><BODY><P>One option is chech in the month list option to no show non selectable values</P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/75885_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/75886_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Thu, 22 Jan 2015 07:04:20 GMT https://community.qlik.com/t5/QlikView/MultiBox-Excluded-values/m-p/746518#M1033964 ecolomer 2015-01-22T07:04:20Z Re: MultiBox Excluded values https://community.qlik.com/t5/QlikView/MultiBox-Excluded-values/m-p/746519#M1033968 <HTML><HEAD></HEAD><BODY><P>Hi Enrique Colomer,</P><P></P><P>Thank you for your solution, actually which you have gave me is the list box example, i knew that one.</P><P>But i want the same in multi box dropdown list</P></BODY></HTML> Thu, 22 Jan 2015 07:51:59 GMT https://community.qlik.com/t5/QlikView/MultiBox-Excluded-values/m-p/746519#M1033968 2015-01-22T07:51:59Z Re: MultiBox Excluded values https://community.qlik.com/t5/QlikView/MultiBox-Excluded-values/m-p/746520#M1033969 <HTML><HEAD></HEAD><BODY><P>Edit the month field in multi box and use this</P><P></P><P>=Aggr(only({&lt;Month=P(Month)&gt;}Month),Month)</P></BODY></HTML> Thu, 22 Jan 2015 10:30:18 GMT https://community.qlik.com/t5/QlikView/MultiBox-Excluded-values/m-p/746520#M1033969 2015-01-22T10:30:18Z Re: MultiBox Excluded values https://community.qlik.com/t5/QlikView/MultiBox-Excluded-values/m-p/746521#M1033970 <HTML><HEAD></HEAD><BODY><P>The Hide Excluded option for MultiBox objects is on the Properties tab. You need to select the Field in the left pane, then tick the box in the right pane.</P><P></P><P>flipside</P></BODY></HTML> Thu, 22 Jan 2015 10:35:53 GMT https://community.qlik.com/t5/QlikView/MultiBox-Excluded-values/m-p/746521#M1033970 flipside 2015-01-22T10:35:53Z Re: MultiBox Excluded values https://community.qlik.com/t5/QlikView/MultiBox-Excluded-values/m-p/746522#M1033971 <HTML><HEAD></HEAD><BODY><P>Thank You for your help</P></BODY></HTML> Thu, 22 Jan 2015 10:56:50 GMT https://community.qlik.com/t5/QlikView/MultiBox-Excluded-values/m-p/746522#M1033971 2015-01-22T10:56:50Z