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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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?