topic Re: Aggregate Text Data (Concat Function, ...) in QlikView

Aggregate Text Data (Concat Function, ...)

Anonymous — Wed, 20 Apr 2016 13:12:25 GMT

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 — Wed, 20 Apr 2016 15:40:12 GMT

May be this:

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

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

Group By Letter;

LOAD * INLINE [

Letter

];

swuehl — Wed, 20 Apr 2016 15:55:55 GMT

Maybe you are looking for a front end solution:

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

Anonymous — Wed, 20 Apr 2016 16:06:37 GMT

Thanks! awesome

sunny_talwar — Wed, 20 Apr 2016 16:09:36 GMT

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