Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Problem with aggr()

Hi to everyone,

I've a problem I can't solve. This is my table:

Field_1Field_2
AX
A-
AX
A-
B-
BX
B-
B-
BY

this is what I need to obtain:

Field_1Field_2
AX
BX, Y

Using the Aggr() function:

Aggr(Field_2,Field_1)

I'm only able to obtain this:

Field_1Field_2
AX
B-

How can I extract also the 'Y'?

Thanks a lot!

1 Solution

Accepted Solutions

Re: Problem with aggr()

Try this

Concat(DISTINCT Field_2, ', ')

4 Replies

Re: Problem with aggr()

Try this

Concat(DISTINCT Field_2, ', ')

Not applicable

Re: Problem with aggr()

The complete syntax was:

Aggr(Concat(DISTINCT Field_2, ','), Field_1)

Not applicable

Re: Problem with aggr()

Great thanks!

Re: Problem with aggr()

Were you using this as a dimension?

Community Browser