topic Re: Aggr Issue in App Development https://community.qlik.com/t5/App-Development/Aggr-Issue/m-p/1407422#M32955 <HTML><HEAD></HEAD><BODY><P>Are you looking at the min ISBN per genre?</P><P></P><P>Maybe</P><P></P><P>=Sum( Aggr( FirstSortedValue( BINDING, ISBN), GENRE))</P></BODY></HTML> Mon, 25 Sep 2017 09:54:14 GMT swuehl 2017-09-25T09:54:14Z Aggr Issue https://community.qlik.com/t5/App-Development/Aggr-Issue/m-p/1407421#M32954 <HTML><HEAD></HEAD><BODY><P>Hi There,</P><P></P><P>Does anyone have a solution for the attached image please?</P><P>Within my table, I want to show BINDING totals from selections where GENRE is the same as the record within the table.</P><P>The image should hopefully explain best.</P><P></P><P>Thank you!</P><P></P><P>small test application also attached should it help.</P></BODY></HTML> Mon, 25 Sep 2017 09:50:43 GMT https://community.qlik.com/t5/App-Development/Aggr-Issue/m-p/1407421#M32954 cmorri1988 2017-09-25T09:50:43Z Re: Aggr Issue https://community.qlik.com/t5/App-Development/Aggr-Issue/m-p/1407422#M32955 <HTML><HEAD></HEAD><BODY><P>Are you looking at the min ISBN per genre?</P><P></P><P>Maybe</P><P></P><P>=Sum( Aggr( FirstSortedValue( BINDING, ISBN), GENRE))</P></BODY></HTML> Mon, 25 Sep 2017 09:54:14 GMT https://community.qlik.com/t5/App-Development/Aggr-Issue/m-p/1407422#M32955 swuehl 2017-09-25T09:54:14Z Re: Aggr Issue https://community.qlik.com/t5/App-Development/Aggr-Issue/m-p/1407423#M32956 <HTML><HEAD></HEAD><BODY><P>Thanks Stefan,</P><P></P><P>Not necessarily the minimum as selection could be any ISBN per Genre.</P><P>Can see why my example would make you think that! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/blush.png" /></P><P></P><P>Thanks,</P><P>Carmelle</P></BODY></HTML> Mon, 25 Sep 2017 09:56:24 GMT https://community.qlik.com/t5/App-Development/Aggr-Issue/m-p/1407423#M32956 cmorri1988 2017-09-25T09:56:24Z Re: Aggr Issue https://community.qlik.com/t5/App-Development/Aggr-Issue/m-p/1407424#M32957 <HTML><HEAD></HEAD><BODY><P>Sum(TOTAL<STRONG>&lt;GENRE&gt;</STRONG> Aggr( BINDING, GENRE))</P><P></P><P>?</P></BODY></HTML> Mon, 25 Sep 2017 10:04:17 GMT https://community.qlik.com/t5/App-Development/Aggr-Issue/m-p/1407424#M32957 swuehl 2017-09-25T10:04:17Z Re: Aggr Issue https://community.qlik.com/t5/App-Development/Aggr-Issue/m-p/1407425#M32958 <HTML><HEAD></HEAD><BODY><P>Perfect, worked wonders!!!</P><P></P><P>Much appreciated!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 25 Sep 2017 10:11:54 GMT https://community.qlik.com/t5/App-Development/Aggr-Issue/m-p/1407425#M32958 cmorri1988 2017-09-25T10:11:54Z