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

Display multiple items for same date

I've created a calendar view to display team time off.  However, when more than one have the day off, I do not see both names.  How can I see this?

Week.PNG

For each of the days above, multiple people are off with Off_Type of either vacation or comp day, with the exception of Wed.

The expression is: [Full Name]& '-' & Off_Type

How can I see all items for each day?

1 Solution

Accepted Solutions
sunny_talwar

May be use Concat() function

Concat(DISTINCT [Full Name] & '-' & Off_Type, Chr(10))

View solution in original post

2 Replies
sunny_talwar

May be use Concat() function

Concat(DISTINCT [Full Name] & '-' & Off_Type, Chr(10))

Not applicable
Author

Perfect...thank you so much!