Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
g_larosa
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 (2)
1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

4 Replies
pradosh_thakur
Master II
Master II

Try something similar

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

Hi Thakur,

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

BR
Giuseppe
sunny_talwar

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

g_larosa
Contributor
Contributor
Author

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