topic Re: Group by in a table in App Development

Group by in a table

g_larosa — Sat, 16 Nov 2024 06:50:55 GMT

Hi,

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

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

(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 — Wed, 16 Jan 2019 08:42:13 GMT

Try something similar

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

g_larosa — Wed, 16 Jan 2019 09:05:34 GMT

Hi Thakur,

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

BR
Giuseppe

sunny_talwar — Wed, 16 Jan 2019 13:10:31 GMT

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

g_larosa — Wed, 16 Jan 2019 14:16:57 GMT

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