Group by in a table

[g_larosa]

Hi,

I have a table in my DataModel like this in Qlik Sense:

NAME	SERVICE
A	service1
A	service2
B	service3
A	service4

and I'd like to create a table (using Table from Charts menu) for my App like this:

NAME	SERVICE
A	service1, service2, service4
B	service2

(just one record for each row)

I know that a Group By in the import can help me, but how can I do it without modify the Auto generate section  ?

[pradosh_thakur]

Try something similar

load NAME, concat(SERVICE,',') AS SERVICE
resident tablename
group by NAME;

[g_larosa]

Hi Thakur,

I'd like to avoid to edit the data generate script and continue to use the data manager.

BR
Giuseppe

[sunny_talwar · Accepted solution]

May be create a chart with dimension NAME and expression Concat(DISTINCT SERVICE, ', ')

[g_larosa]

Super !, my fault was set SERVICE as dimension (rather than misure)