https://community.qlik.com/t5/App-Development/Display-dimension-values-in-a-list/m-p/1548263#M39469 <P>Hello,</P><P>I'm using a heat map object and the class function to display the number of associates by amount of overtime worked and transactions per hour. I'd like the mouse-over to display a list of associates falling within the various buckets.</P><P>I'm able to do this if there is only one associate in the bucket by adding a second measure "=Only(Assoc_ID)." In cases where there is more than one associate in the bucket, it only displays a "-" to indicate more than one.&nbsp;</P><P>Is it possible to display the array of associates as a comma delimited string when there&nbsp; is more than one associate in the bucket? If so, how would I do this.</P><P>Thank you for any assistance you can provide.</P><P>-Frank</P> Fri, 22 Feb 2019 21:16:33 GMT phuelish 2019-02-22T21:16:33Z https://community.qlik.com/t5/App-Development/Display-dimension-values-in-a-list/m-p/1548263#M39469 <P>Hello,</P><P>I'm using a heat map object and the class function to display the number of associates by amount of overtime worked and transactions per hour. I'd like the mouse-over to display a list of associates falling within the various buckets.</P><P>I'm able to do this if there is only one associate in the bucket by adding a second measure "=Only(Assoc_ID)." In cases where there is more than one associate in the bucket, it only displays a "-" to indicate more than one.&nbsp;</P><P>Is it possible to display the array of associates as a comma delimited string when there&nbsp; is more than one associate in the bucket? If so, how would I do this.</P><P>Thank you for any assistance you can provide.</P><P>-Frank</P> Fri, 22 Feb 2019 21:16:33 GMT https://community.qlik.com/t5/App-Development/Display-dimension-values-in-a-list/m-p/1548263#M39469 phuelish 2019-02-22T21:16:33Z https://community.qlik.com/t5/App-Development/Display-dimension-values-in-a-list/m-p/1548265#M39470 <P>Nevermind...figured it out</P><P>if(count(distinct Assoc_ID)&gt;1,Concat(distinct aggr(Assoc_ID,Assoc_ID),', '),Only(Assoc_ID))</P> Fri, 22 Feb 2019 21:32:13 GMT https://community.qlik.com/t5/App-Development/Display-dimension-values-in-a-list/m-p/1548265#M39470 phuelish 2019-02-22T21:32:13Z