topic Re: Can I apply a set expression to a filter pane? in QlikView https://community.qlik.com/t5/QlikView/Can-I-apply-a-set-expression-to-a-filter-pane/m-p/1390741#M799253 <HTML><HEAD></HEAD><BODY><P>I think it should... I don't see why it wouldn't</P></BODY></HTML> Wed, 29 Nov 2017 01:39:15 GMT sunny_talwar 2017-11-29T01:39:15Z Can I apply a set expression to a filter pane? https://community.qlik.com/t5/QlikView/Can-I-apply-a-set-expression-to-a-filter-pane/m-p/1390736#M799248 <HTML><HEAD></HEAD><BODY><P>Can I apply a set expression to a filter pane?</P><P></P><P>I have a country column and continent column:</P><P></P><P>I want to use Country as a filter but only show Countries from ASIA. Is it possible? </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Can-I-apply-a-set-expression-to-a-filter-pane/m-p/1390736#M799248 rvijayanth 2020-11-25T16:16:04Z Re: Can I apply a set expression to a filter pane? https://community.qlik.com/t5/QlikView/Can-I-apply-a-set-expression-to-a-filter-pane/m-p/1390737#M799249 <HTML><HEAD></HEAD><BODY><P>In a list box expression you can use any one of the expression:</P><P></P><P>=Aggr(Only({&lt;Continent = {'Asia'}&gt;} Country), Country)</P><P></P><P>OR</P><P></P><P>=If(MixMatch(Continent,'Asia'),Country)</P></BODY></HTML> Wed, 29 Nov 2017 00:36:41 GMT https://community.qlik.com/t5/QlikView/Can-I-apply-a-set-expression-to-a-filter-pane/m-p/1390737#M799249 trdandamudi 2017-11-29T00:36:41Z Re: Can I apply a set expression to a filter pane? https://community.qlik.com/t5/QlikView/Can-I-apply-a-set-expression-to-a-filter-pane/m-p/1390738#M799250 <HTML><HEAD></HEAD><BODY><P>What set expression you are going with? I mean which aggregate needed? Read this <A href="http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/SetAnalysis/set-analysis-expressions.htm" title="http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/SetAnalysis/set-analysis-expressions.htm">Set analysis and set expressions ‒ QlikView</A></P></BODY></HTML> Wed, 29 Nov 2017 01:15:05 GMT https://community.qlik.com/t5/QlikView/Can-I-apply-a-set-expression-to-a-filter-pane/m-p/1390738#M799250 Anil_Babu_Samineni 2017-11-29T01:15:05Z Re: Can I apply a set expression to a filter pane? https://community.qlik.com/t5/QlikView/Can-I-apply-a-set-expression-to-a-filter-pane/m-p/1390739#M799251 <HTML><HEAD></HEAD><BODY><P>This is exactly what Im looking for but I forgot to mention it is in QlikSense. Is this possible in QlikSense?</P></BODY></HTML> Wed, 29 Nov 2017 01:24:37 GMT https://community.qlik.com/t5/QlikView/Can-I-apply-a-set-expression-to-a-filter-pane/m-p/1390739#M799251 rvijayanth 2017-11-29T01:24:37Z Re: Can I apply a set expression to a filter pane? https://community.qlik.com/t5/QlikView/Can-I-apply-a-set-expression-to-a-filter-pane/m-p/1390740#M799252 <HTML><HEAD></HEAD><BODY><P>I do not have Qliksense, but you can give a try. I think it might work...</P></BODY></HTML> Wed, 29 Nov 2017 01:26:50 GMT https://community.qlik.com/t5/QlikView/Can-I-apply-a-set-expression-to-a-filter-pane/m-p/1390740#M799252 trdandamudi 2017-11-29T01:26:50Z Re: Can I apply a set expression to a filter pane? https://community.qlik.com/t5/QlikView/Can-I-apply-a-set-expression-to-a-filter-pane/m-p/1390741#M799253 <HTML><HEAD></HEAD><BODY><P>I think it should... I don't see why it wouldn't</P></BODY></HTML> Wed, 29 Nov 2017 01:39:15 GMT https://community.qlik.com/t5/QlikView/Can-I-apply-a-set-expression-to-a-filter-pane/m-p/1390741#M799253 sunny_talwar 2017-11-29T01:39:15Z Re: Can I apply a set expression to a filter pane? https://community.qlik.com/t5/QlikView/Can-I-apply-a-set-expression-to-a-filter-pane/m-p/1390742#M799254 <HTML><HEAD></HEAD><BODY><P>It worked. Thanks everyone. </P><P></P><P>Btw I used <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=If(MixMatch(Continent,'Asia'),Country)</SPAN></P></BODY></HTML> Wed, 29 Nov 2017 05:08:37 GMT https://community.qlik.com/t5/QlikView/Can-I-apply-a-set-expression-to-a-filter-pane/m-p/1390742#M799254 rvijayanth 2017-11-29T05:08:37Z