Aggregate Text Data (Concat Function, ...)

[Anonymous]

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]

May be this:

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

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

Group By Letter;

LOAD * INLINE [

Letter

A

A

B

B

B

C

C

C

];

[swuehl]

Maybe you are looking for a front end solution:

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

[Anonymous]

Thanks! awesome

[sunny_talwar]

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

Qlik Community Tip: Marking Replies as Correct or Helpful