topic pivot question with min and max in QlikView https://community.qlik.com/t5/QlikView/pivot-question-with-min-and-max/m-p/190610#M53048 <HTML><HEAD></HEAD><BODY><P>min(aggr(Sum(Bedrag), Group))</P><P>ok .. this works .. but how do i get the coresponding teamname with this output?</P></BODY></HTML> Tue, 23 Mar 2010 21:00:27 GMT amien 2010-03-23T21:00:27Z pivot question with min and max https://community.qlik.com/t5/QlikView/pivot-question-with-min-and-max/m-p/190609#M53047 <HTML><HEAD></HEAD><BODY><P>i have this pivot:</P><P>dimension : group,team</P><P>expression: sum(value)</P><P>data:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />group, team, value<BR />group1, team1, 5<BR />group1, team1, 10<BR />group1, team2, 5<BR />group1, team3, 1<BR />group2, team1, 100<BR />group2, team2, 500</PRE><BR /><BR /> <P>i want this in a pivot as output</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />group, min team, max team, min value, max value<BR />group1, team3, team1, value_team3, value_team1<BR />group2, team1, team2, value_team1, value_team2<BR /></PRE><BR /><BR /> <P></P><P>how can i do this?</P><P></P><P></P></BODY></HTML> Tue, 23 Mar 2010 20:43:20 GMT https://community.qlik.com/t5/QlikView/pivot-question-with-min-and-max/m-p/190609#M53047 amien 2010-03-23T20:43:20Z pivot question with min and max https://community.qlik.com/t5/QlikView/pivot-question-with-min-and-max/m-p/190610#M53048 <HTML><HEAD></HEAD><BODY><P>min(aggr(Sum(Bedrag), Group))</P><P>ok .. this works .. but how do i get the coresponding teamname with this output?</P></BODY></HTML> Tue, 23 Mar 2010 21:00:27 GMT https://community.qlik.com/t5/QlikView/pivot-question-with-min-and-max/m-p/190610#M53048 amien 2010-03-23T21:00:27Z