Concat aggregation with dynamic dimension

Thu, 04 Feb 2016 14:55:33 GMT

Hello,

I like to aggregate and concat the following data into a text object but can't state the Team name in a dynamic manner.

TEAM
Core	3.00	3.18	3.94
Improve	2.60	4.40	4.67
Sales & Marketing	3.75	3.75	4.50
Spark!	3.00	3.00	5.50
Support	2.67	3.00	3.50
Touch	2.43	3.17	3.83

Below is the output of my expression and the scores per team are successfully concatenated. But the Team name is wrong. It shows the Team 'Core' which is the first in the list. The team name needs to correspond with the aggregated data (like Core, Improve, Sales & Marketing, Spark!, Support, Touch).

How can I state the Team name in a dynamical manner?

This is the expression:

=Team&':'

concat(

Aggr(

concat(

num(

Aggr(

avg({$<#answer ={"<=100"}, Indi# = {1}, Dimension = {Klimaat}>}#answer)

, Variable, Team)

,'#.##')

,',')

,Team)

,Team&':')

topic Concat aggregation with dynamic dimension in QlikView

Concat aggregation with dynamic dimension