Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Dimension aggregation

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
IDNAME CITY ROLE
1NITESHA DALLASDirector
1NITESHA DALLAS

Senior Manager

output
IDNAME CITY ROLE
1NITESHA DALLASDirector , Senior Manager
3 Replies
Not applicable

Re: Dimension aggregation

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

Director

Senior Manager

Partner
Partner

Re: Dimension aggregation

Try

CONCAT(DISTINCT ROLE,',')

MVP
MVP

Re: Dimension aggregation

Expression Concat(DISTINCT ROLE, chr(13))

Dimension ID

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein