Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
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
Highlighted

Re: How to create this chart?

Hi

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

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

     Hope it helps

View solution in original post

2 Replies
Highlighted

Re: How to create this chart?

Hi

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

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

     Hope it helps

View solution in original post

Highlighted
Not applicable

Re: How to create this chart?

Thank you Mayil,

This worked just fine.

Regards,

Jim