Discussion board where members can get started with QlikView.
In a straight table, i have the below data:
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:
I also need only distinct countries to be displayed.
I tried "CONCAT(COUNTRY,',') , but its not working.
Any help would be appreciated.
Aggr(Concat(DISTINCT COUNTRY, ', '), Name, Number, Date, Cost)
Did you try
as expression or (calculated) dimension?
Using it as expression with Name, Number, Date, Cost as dimensions should work.
hope this helps
I tried it as a calculated dimension initially.
But when i tried the condition suggested by Sunny in Calculated dimension, it worked fine.