Dimension aggregation

[#1]

Can someone help me with this. I am trying to achieve what is mentioned below.

Please share how to get done on qliksense from UI.  

Input
ID	NAME	CITY	ROLE
1	NITESHA	DALLAS	Director
1	NITESHA	DALLAS	Senior Manager
output
ID	NAME	CITY	ROLE
1	NITESHA	DALLAS	Director , Senior Manager

[#2]

I want the out role should be  like . It must be separated by chr(13)

Director

Senior Manager

[shraddha_g]

Try

CONCAT(DISTINCT ROLE,',')

[jonathandienst]

Expression Concat(DISTINCT ROLE, chr(13))

Dimension ID