Discussion Board for collaboration related to QlikView App Development.
I wondering if you could concatenate several rows from the same column grouped by a dimension. Example:
The final result would be:
2011-01-01, One Two Three Four
In this case I am reading the data via a webfile by using the XML parser.
Try to load like
Concat(Comment,' ') as NewComment
Group by Date;
See the attached sample file.
View solution in original post
The previous solution not is complete, pls to see image atteched
Good luck, Luis.
Just simply add "Distinct" after the Load.
Hope it works,
Thanks Luis, your solution helped me