Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
In a straight table, i have the below data:
Name | Number | Date | Cost | Country |
---|---|---|---|---|
ABC Enterprise | 1234 | 13-JUN-18 | 100 | USA |
ABC Enterprise | 1234 | 13-JUN-18 | 100 | UK |
ABC Enterprise | 1234 | 13-JUN-18 | 100 | FRANCE |
If i remove the Country column, then i only get one row.
How can i add the country column and make the row comma separated so that i get only one row? like below:
Name | Number | Date | Cost | Country |
---|---|---|---|---|
ABC Enterprise | 1234 | 13-JUN-18 | 100 | USA,UK,FRANCE |
I also need only distinct countries to be displayed.
I tried "CONCAT(COUNTRY,',') , but its not working.
Any help would be appreciated.
Thanks
Taher
Try this
Aggr(Concat(DISTINCT COUNTRY, ', '), Name, Number, Date, Cost)
Did you try
CONCAT(COUNTRY,',')
as expression or (calculated) dimension?
Using it as expression with Name, Number, Date, Cost as dimensions should work.
hope this helps
regards
Marco
Hi Macro
I tried it as a calculated dimension initially.
But when i tried the condition suggested by Sunny in Calculated dimension, it worked fine.
Thanks
Hi, Sunny I tried this in Qlik Sense it's not working and error is produced at first bracket itself. Please let me know if syntax needs to be different for Qlik Sense