Aggregate Text Data (Concat Function, ...) - Qlik Community

Anonymous · ‎2016-04-20

Hello,

is it possible to extent the concat function with aggregation functions?

I have the following table.:

LOAD * INLINE [
Letter
A
A
B
B
B
C
C
C
];

I need to count the letters and save the result in in one string:

A = 2, B = 3, C = 3

I tried something like concat(DISTINCT Letter&COUNT(Letter),', ')

Does anyone has an idea to solve this problem?

thanks and best regards

sunny_talwar · ‎2016-04-20

May be this:

LOAD Concat(New, ', ') as Final;

LOAD Only(Letter) & ' = ' & Count(Letter) as New

Group By Letter;

LOAD * INLINE [

Letter

A

B

C

];

swuehl · ‎2016-04-20

Maybe you are looking for a front end solution:

=Concat(Aggr(Letter & ' = ' & Count(Letter), Letter),',')

Anonymous · ‎2016-04-20

Thanks! awesome

sunny_talwar · ‎2016-04-20

Please close this thread if you got what you were looking for