topic Re: Hide some values in multi box in QlikView https://community.qlik.com/t5/QlikView/Hide-some-values-in-multi-box/m-p/1249260#M859584 <HTML><HEAD></HEAD><BODY><P>=If(WildMatch(HourOffSet, '*-*'), HourOffSet)</P></BODY></HTML> Sat, 28 Jan 2017 13:06:20 GMT maxgro 2017-01-28T13:06:20Z Hide some values in multi box https://community.qlik.com/t5/QlikView/Hide-some-values-in-multi-box/m-p/1249257#M859581 <HTML><HEAD></HEAD><BODY><P>hi every one,</P><P>my requirement is to hide some values in multi box.</P><P>iam trying one format but its not working .</P><P>=aggr(only({&lt;HourOffset-={'&lt;0'}&gt;}HourOffset),HourOffset)</P><P></P><P></P><P>my data is like this</P><P>HourOffSet &lt;0</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0-12</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12-24</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24-48</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;48</P><P></P><P>i dont want to display &lt;0 and &gt;48 values in multi-box.</P><P></P><P>thank in advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Hide-some-values-in-multi-box/m-p/1249257#M859581 Anonymous 2020-11-25T16:16:04Z Re: Hide some values in multi box https://community.qlik.com/t5/QlikView/Hide-some-values-in-multi-box/m-p/1249258#M859582 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG>If(not WildMatch(HourOffSet, '*&gt;*', '*&gt;*'), HourOffSet)</STRONG></P></BODY></HTML> Sat, 28 Jan 2017 12:21:17 GMT https://community.qlik.com/t5/QlikView/Hide-some-values-in-multi-box/m-p/1249258#M859582 sunny_talwar 2017-01-28T12:21:17Z Re: Hide some values in multi box https://community.qlik.com/t5/QlikView/Hide-some-values-in-multi-box/m-p/1249259#M859583 <HTML><HEAD></HEAD><BODY><P>Or this</P><P></P><P><STRONG>=Aggr(Only({1&lt;HourOffset - = {'*&lt;*', '*&gt;*'}&gt;} HourOffset), HourOffset)</STRONG></P></BODY></HTML> Sat, 28 Jan 2017 12:22:04 GMT https://community.qlik.com/t5/QlikView/Hide-some-values-in-multi-box/m-p/1249259#M859583 sunny_talwar 2017-01-28T12:22:04Z Re: Hide some values in multi box https://community.qlik.com/t5/QlikView/Hide-some-values-in-multi-box/m-p/1249260#M859584 <HTML><HEAD></HEAD><BODY><P>=If(WildMatch(HourOffSet, '*-*'), HourOffSet)</P></BODY></HTML> Sat, 28 Jan 2017 13:06:20 GMT https://community.qlik.com/t5/QlikView/Hide-some-values-in-multi-box/m-p/1249260#M859584 maxgro 2017-01-28T13:06:20Z