Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
amien
Specialist
Specialist

pivot question with min and max

i have this pivot:

dimension : group,team

expression: sum(value)

data:


group, team, value
group1, team1, 5
group1, team1, 10
group1, team2, 5
group1, team3, 1
group2, team1, 100
group2, team2, 500


i want this in a pivot as output


group, min team, max team, min value, max value
group1, team3, team1, value_team3, value_team1
group2, team1, team2, value_team1, value_team2


how can i do this?

1 Reply
amien
Specialist
Specialist
Author

min(aggr(Sum(Bedrag), Group))

ok .. this works .. but how do i get the coresponding teamname with this output?