Discussion Board for collaboration on QlikView Layout & Visualizations.
I have four three items of data:
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...
Use pivot table, Use Location and Date as dimension ..
And Use Concat(Distinct PersonName, ',') as Expression
Hope it helps
View solution in original post
Thank you Mayil,
This worked just fine.