Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Group by in a table

Hi,

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

NAMESERVICE
Aservice1
Aservice2
Bservice3
Aservice4

 

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

NAMESERVICE
Aservice1, service2, service4
Bservice2

 

(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  ?

Labels (1)
1 Solution

Accepted Solutions
Highlighted

Re: Group by in a table

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

View solution in original post

4 Replies
Highlighted
Master II
Master II

Re: Group by in a table

Try something similar

load NAME, concat(SERVICE,',') AS SERVICE
resident tablename
group by NAME;
Learning never stops.
Highlighted
Contributor
Contributor

Re: Group by in a table

Hi Thakur,

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

BR
Giuseppe
Highlighted

Re: Group by in a table

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

View solution in original post

Highlighted
Contributor
Contributor

Re: Group by in a table

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