Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Concat aggregation with dynamic dimension

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).

Capturey.PNG

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&':')

0 Replies