topic set analysis in QlikView https://community.qlik.com/t5/QlikView/set-analysis/m-p/1362559#M417419 <HTML><HEAD></HEAD><BODY><P>Hello community</P><P></P><P>this is my table</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Category</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Rent</STRONG></TH></TR><TR><TD style="padding: 2px;">Car</TD><TD style="padding: 2px;">1.000.000</TD><TD style="padding: 2px;">15.000</TD></TR><TR><TD style="padding: 2px;">Motorbike</TD><TD style="padding: 2px;">800.000</TD><TD style="padding: 2px;">14.500</TD></TR><TR><TD style="padding: 2px;">Truck</TD><TD style="padding: 2px;">750.000</TD><TD style="padding: 2px;">17.000</TD></TR></TBODY></TABLE><P></P><P>I wanna create a text object which returns me the rent from the biggest category referring to sales</P><P></P><P>Example:</P><P></P><P>Biggest Category from Sales = Car with 1.000.000</P><P>QV should return me 15.000</P><P></P><P></P><P>I tried this expression:</P><P></P><P>=Max(TOTAL Aggr(Sum(Sales), Category))</P><P></P><P>QV returns me 17.000</P><P></P><P></P><P>Can anyone help me out here?</P></BODY></HTML> Wed, 17 May 2017 15:07:46 GMT thanhphongle 2017-05-17T15:07:46Z set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/1362559#M417419 <HTML><HEAD></HEAD><BODY><P>Hello community</P><P></P><P>this is my table</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Category</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Rent</STRONG></TH></TR><TR><TD style="padding: 2px;">Car</TD><TD style="padding: 2px;">1.000.000</TD><TD style="padding: 2px;">15.000</TD></TR><TR><TD style="padding: 2px;">Motorbike</TD><TD style="padding: 2px;">800.000</TD><TD style="padding: 2px;">14.500</TD></TR><TR><TD style="padding: 2px;">Truck</TD><TD style="padding: 2px;">750.000</TD><TD style="padding: 2px;">17.000</TD></TR></TBODY></TABLE><P></P><P>I wanna create a text object which returns me the rent from the biggest category referring to sales</P><P></P><P>Example:</P><P></P><P>Biggest Category from Sales = Car with 1.000.000</P><P>QV should return me 15.000</P><P></P><P></P><P>I tried this expression:</P><P></P><P>=Max(TOTAL Aggr(Sum(Sales), Category))</P><P></P><P>QV returns me 17.000</P><P></P><P></P><P>Can anyone help me out here?</P></BODY></HTML> Wed, 17 May 2017 15:07:46 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/1362559#M417419 thanhphongle 2017-05-17T15:07:46Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/1362560#M417420 <HTML><HEAD></HEAD><BODY><P>Try :</P><P></P><P>FirstSortedValue( Rent, - Sales)</P></BODY></HTML> Wed, 17 May 2017 15:09:50 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/1362560#M417420 tresB 2017-05-17T15:09:50Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/1362561#M417421 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>Sum({&lt;Category = {"=Rank(Sum(Sales))=1"}&gt;} Rent)</P></BODY></HTML> Wed, 17 May 2017 15:11:11 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/1362561#M417421 swuehl 2017-05-17T15:11:11Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/1362562#M417422 <HTML><HEAD></HEAD><BODY><P>works good! thank you</P></BODY></HTML> Wed, 17 May 2017 15:17:59 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/1362562#M417422 thanhphongle 2017-05-17T15:17:59Z