topic Re: Associated data to be selected in list box in QlikView https://community.qlik.com/t5/QlikView/Associated-data-to-be-selected-in-list-box/m-p/712999#M256656 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Try with Count ({1&lt;emailID=P(emailID)&gt;} mbrID)</P></BODY></HTML> Sun, 20 Jul 2014 17:28:08 GMT sebastiandperei 2014-07-20T17:28:08Z Associated data to be selected in list box https://community.qlik.com/t5/QlikView/Associated-data-to-be-selected-in-list-box/m-p/712998#M256655 <HTML><HEAD></HEAD><BODY><P>Hi, I am using member Id is the key to represent the data in dashboard. But now, I want to show accounts associated to&nbsp; emailID in a object of same sheet.</P><P>I used below expression to avoid all filters on object except Email ID.</P><P>&nbsp;&nbsp;&nbsp; count({&lt;$(=concat({1&lt;$Field-={'mbrEmailAddress'}&gt;} '[' &amp; $Field &amp; ']=',','))&gt;} mbrID)</P><P></P><P>It works fine but I have to select associated email ID as selected. Is there any other solution to make associted emailID can be selected to show accounts?</P></BODY></HTML> Sun, 20 Jul 2014 17:17:11 GMT https://community.qlik.com/t5/QlikView/Associated-data-to-be-selected-in-list-box/m-p/712998#M256655 Anonymous 2014-07-20T17:17:11Z Re: Associated data to be selected in list box https://community.qlik.com/t5/QlikView/Associated-data-to-be-selected-in-list-box/m-p/712999#M256656 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Try with Count ({1&lt;emailID=P(emailID)&gt;} mbrID)</P></BODY></HTML> Sun, 20 Jul 2014 17:28:08 GMT https://community.qlik.com/t5/QlikView/Associated-data-to-be-selected-in-list-box/m-p/712999#M256656 sebastiandperei 2014-07-20T17:28:08Z