topic Re: How to filter values in List box based on the value in variable ? in QlikView https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335934#M412082 <HTML><HEAD></HEAD><BODY><P>Hi Shekhar,</P><P></P><P>Please find the attached app.</P><P></P><P>I just edited the expression in the list box with '=match_id'. And also checked the 'Hide Excluded' option.</P></BODY></HTML> Wed, 02 Aug 2017 11:10:34 GMT kusumanchir 2017-08-02T11:10:34Z How to filter values in List box based on the value in variable ? https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335928#M412076 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><P>How to filter values in List box based on the value in variable ?</P><P></P><P>In the attached app based on the season i want the match ids to be filtered in List box . <BR />Example - if user selects season 1 then in list box , only the match id of season 1 should be shown .</P><P></P><P>Thanks &amp; Regards</P><P>Shekar</P></BODY></HTML> Wed, 02 Aug 2017 10:14:48 GMT https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335928#M412076 shekhar_analyti 2017-08-02T10:14:48Z Re: How to filter values in List box based on the value in variable ? https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335929#M412077 <HTML><HEAD></HEAD><BODY><P>There is no app is attached. Please attached the same.</P></BODY></HTML> Wed, 02 Aug 2017 10:16:44 GMT https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335929#M412077 senpradip007 2017-08-02T10:16:44Z Re: How to filter values in List box based on the value in variable ? https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335930#M412078 <HTML><HEAD></HEAD><BODY><P>Sorry For missing that ..</P><P></P><P>Please find attached</P></BODY></HTML> Wed, 02 Aug 2017 10:24:46 GMT https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335930#M412078 shekhar_analyti 2017-08-02T10:24:46Z Re: How to filter values in List box based on the value in variable ? https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335931#M412079 <HTML><HEAD></HEAD><BODY><P>Have a look at this.</P></BODY></HTML> Wed, 02 Aug 2017 10:34:03 GMT https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335931#M412079 senpradip007 2017-08-02T10:34:03Z Re: How to filter values in List box based on the value in variable ? https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335932#M412080 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>try this in List Box</P><P><SPAN style="font-size: 10pt;">=</SPAN><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">Aggr</SPAN>(<SPAN style="color: #0000ff;">Only</SPAN>({&lt;<SPAN style="color: #800000;">match_id</SPAN>=<SPAN style="color: #0000ff;">P</SPAN>({&lt;<SPAN style="color: #800000;">season</SPAN>={'$(vSelect_Season)'}&gt;})&gt;} <SPAN style="color: #800000;">match_id</SPAN>),<SPAN style="color: #800000;">match_id</SPAN></SPAN><SPAN style="font-size: 10pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Antonio</SPAN></P></BODY></HTML> Wed, 02 Aug 2017 10:54:06 GMT https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335932#M412080 antoniotiman 2017-08-02T10:54:06Z Re: How to filter values in List box based on the value in variable ? https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335933#M412081 <HTML><HEAD></HEAD><BODY><P>Thanks Antonio , this is exactly what was required</P></BODY></HTML> Wed, 02 Aug 2017 11:09:34 GMT https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335933#M412081 shekhar_analyti 2017-08-02T11:09:34Z Re: How to filter values in List box based on the value in variable ? https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335934#M412082 <HTML><HEAD></HEAD><BODY><P>Hi Shekhar,</P><P></P><P>Please find the attached app.</P><P></P><P>I just edited the expression in the list box with '=match_id'. And also checked the 'Hide Excluded' option.</P></BODY></HTML> Wed, 02 Aug 2017 11:10:34 GMT https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335934#M412082 kusumanchir 2017-08-02T11:10:34Z Re: How to filter values in List box based on the value in variable ? https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335935#M412083 <HTML><HEAD></HEAD><BODY><P>But on selecting any value in the list box having expression</P><P>(<SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">Aggr</SPAN>(<SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">Only</SPAN>({&lt;<SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #800000;">match_id</SPAN>=<SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #0000ff;">P</SPAN>({&lt;<SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #800000;">season</SPAN>={'$(vSelect_Season)'}&gt;})&gt;} <SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #800000;">match_id</SPAN>),<SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit; color: #800000;">match_id</SPAN></SPAN><SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">)) , makes other values to disappear .</SPAN></P><P><SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Cant we keep other values intact , even on selection ? <BR /><BR /></SPAN></P></BODY></HTML> Wed, 02 Aug 2017 11:11:49 GMT https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335935#M412083 shekhar_analyti 2017-08-02T11:11:49Z Re: How to filter values in List box based on the value in variable ? https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335936#M412084 <HTML><HEAD></HEAD><BODY><P>i'm afraid not, This is behavior of Aggr() function.</P></BODY></HTML> Wed, 02 Aug 2017 11:55:15 GMT https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335936#M412084 antoniotiman 2017-08-02T11:55:15Z Re: How to filter values in List box based on the value in variable ? https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335937#M412085 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌ ... any workaround ?</P></BODY></HTML> Wed, 02 Aug 2017 12:41:16 GMT https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335937#M412085 shekhar_analyti 2017-08-02T12:41:16Z Re: How to filter values in List box based on the value in variable ? https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335938#M412086 <HTML><HEAD></HEAD><BODY><P>Have You tried <A href="https://community.qlik.com/qlik-users/91207">senpradip007</A> solution ?</P></BODY></HTML> Wed, 02 Aug 2017 12:52:09 GMT https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335938#M412086 antoniotiman 2017-08-02T12:52:09Z Re: How to filter values in List box based on the value in variable ? https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335939#M412087 <HTML><HEAD></HEAD><BODY><P>What about</P><P>Botton Season 1/2/....</P><P>like this&nbsp; (instead of set variables)</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172223_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>List Box with match_id field</P></BODY></HTML> Wed, 02 Aug 2017 13:47:14 GMT https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335939#M412087 antoniotiman 2017-08-02T13:47:14Z Re: How to filter values in List box based on the value in variable ? https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335940#M412088 <HTML><HEAD></HEAD><BODY><P>I have seen his solution but , i do not want to use action like select in field . I was trying to find solution around some set expression ..</P></BODY></HTML> Thu, 03 Aug 2017 05:22:03 GMT https://community.qlik.com/t5/QlikView/How-to-filter-values-in-List-box-based-on-the-value-in-variable/m-p/1335940#M412088 shekhar_analyti 2017-08-03T05:22:03Z