Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

vinod2086
Contributor II

comma separated value based on single field

Hi friends,

i have a requirement

 

IDName1
1Anil
2Sunil
2Raju
3ravi
4vinod
4ramu
3krishna
1raja
2muni

for single id here it is displaying multiple name instead of displaying multiple values user wants single row and comma separated for ex

id 1 is displaying 2 times user expecting like this

id  name1

1  anil,raja

Thanks in advance

3 Replies
MVP & Luminary
MVP & Luminary

Re: comma separated value based on single field

Create a straight table object and use ID as dimension and =concat(distinct Name1, ',', Name1) as expression


talk is cheap, supply exceeds demand

Re: comma separated value based on single field

Data:

LOAD ID,

           Concat(distinct name1 ,',') as name1

FROM table

group by ID;

Re: comma separated value based on single field

Try,

Data:

Load ID,

Concat(Name1, ', ') as Name1,

Concat(No,', ') as No,

Sum(Sal) as Sales

FROM

(ooxml, embedded labels, table is Sheet1) Group by ID;

Output:

Capture.PNG