Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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))