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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create this chart?

Hello All,

I have four three items of data:

ID,

PersonName,

Date,

Location

I would like to create a chart that has the date accross the top, the location down the left, and the persons name(s) in the middle combined.

The dates should be distinct, so for example the 1/3/2012 should only appear once and the names will be combined into one field.

Having difficulties doing this. Have tried to use a straight table and pivot table but have no luck. Names seem to be missing even though selected.

I would like to have what is shown in the attached excel file. Sample data also attached on second tab.

Thanks for any help that you could provide...

Regards,

Jim

1 Solution

Accepted Solutions
MayilVahanan

Hi

     Use pivot table, Use Location and Date as dimension ..

     And Use Concat(Distinct PersonName, ',') as Expression

     Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

Hi

     Use pivot table, Use Location and Date as dimension ..

     And Use Concat(Distinct PersonName, ',') as Expression

     Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Thank you Mayil,

This worked just fine.

Regards,

Jim