Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
phuelish
Contributor III
Contributor III

Display dimension values in a list

Hello,

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.

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. 

Is it possible to display the array of associates as a comma delimited string when there  is more than one associate in the bucket? If so, how would I do this.

Thank you for any assistance you can provide.

-Frank

1 Solution

Accepted Solutions
phuelish
Contributor III
Contributor III
Author

Nevermind...figured it out

if(count(distinct Assoc_ID)>1,Concat(distinct aggr(Assoc_ID,Assoc_ID),', '),Only(Assoc_ID))

View solution in original post

1 Reply
phuelish
Contributor III
Contributor III
Author

Nevermind...figured it out

if(count(distinct Assoc_ID)>1,Concat(distinct aggr(Assoc_ID,Assoc_ID),', '),Only(Assoc_ID))