Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
I want the out role should be like . It must be separated by chr(13)
Director
Senior Manager
Try
CONCAT(DISTINCT ROLE,',')
Expression Concat(DISTINCT ROLE, chr(13))
Dimension ID