topic Indirect Set Analysis and List Box in App Development https://community.qlik.com/t5/App-Development/Indirect-Set-Analysis-and-List-Box/m-p/1235547#M24334 <HTML><HEAD></HEAD><BODY><P>Attached a picture that explains the problem.</P><P></P><P>I use a P() set analysis expression for answering to a query that requires an intersection between two sets.</P><P>The count calculation is correct.</P><P></P><P>Problem: The list box shows all the values while I want to show only the selected values by the expression (in this case just one - the "id1").</P><P><SPAN style="font-size: 8pt;"><EM>(Actually, I solved the problem using the Aggr() ("Interceptor" in the picture) but I don't like it as the Aggr() is a very resource consuming)</EM></SPAN></P><P></P><P>How to solve in a way more elegant and efficient?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 08 Feb 2017 13:24:36 GMT ciampaciampa 2017-02-08T13:24:36Z Indirect Set Analysis and List Box https://community.qlik.com/t5/App-Development/Indirect-Set-Analysis-and-List-Box/m-p/1235547#M24334 <HTML><HEAD></HEAD><BODY><P>Attached a picture that explains the problem.</P><P></P><P>I use a P() set analysis expression for answering to a query that requires an intersection between two sets.</P><P>The count calculation is correct.</P><P></P><P>Problem: The list box shows all the values while I want to show only the selected values by the expression (in this case just one - the "id1").</P><P><SPAN style="font-size: 8pt;"><EM>(Actually, I solved the problem using the Aggr() ("Interceptor" in the picture) but I don't like it as the Aggr() is a very resource consuming)</EM></SPAN></P><P></P><P>How to solve in a way more elegant and efficient?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 08 Feb 2017 13:24:36 GMT https://community.qlik.com/t5/App-Development/Indirect-Set-Analysis-and-List-Box/m-p/1235547#M24334 ciampaciampa 2017-02-08T13:24:36Z Re: Indirect Set Analysis and List Box https://community.qlik.com/t5/App-Development/Indirect-Set-Analysis-and-List-Box/m-p/1235548#M24335 <HTML><HEAD></HEAD><BODY><P>If you want to use set analysis, then Aggr() might be the only solution... I can't think of a way to avoid the use of Aggr()</P></BODY></HTML> Wed, 08 Feb 2017 16:15:08 GMT https://community.qlik.com/t5/App-Development/Indirect-Set-Analysis-and-List-Box/m-p/1235548#M24335 sunny_talwar 2017-02-08T16:15:08Z