topic Max Amount Supplier in QlikView https://community.qlik.com/t5/QlikView/Max-Amount-Supplier/m-p/408443#M151900 <HTML><HEAD></HEAD><BODY><P>Hi, How can I create a variable that bring the supplier ID with maximum amount in any period selected?</P><P></P><P>I need to compare the amount of each provider on the most participation has.</P><P></P><P>Example:</P><P>Max Amount Supplier</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="91" style="width: 286px; border: 1px solid #000000; height: 81px;" width="284"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Year</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Amount</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID_Supplier</STRONG></SPAN></TH></TR><TR><TD>2010</TD><TD>$100.000</TD><TD>123</TD></TR><TR><TD>2011</TD><TD>$120.000</TD><TD>444</TD></TR><TR><TD>2012</TD><TD>$110.000</TD><TD>999</TD></TR></TBODY></TABLE><P></P><P></P><P>After this I may have to make a table like this:</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="153" style="width: 496px; border: 1px solid rgb(0, 0, 0); height: 152px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Year</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID_Supplier</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Amount</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Amount_Max_Supplier</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Amount / <STRONG style="color: #ffffff; text-align: -webkit-center; background-color: #6690bc;">Amount_Max_Supplier</STRONG></STRONG></SPAN></TH></TR><TR><TD>2010</TD><TD>111</TD><TD>$20.000</TD><TD>$100.000</TD><TD>20%</TD></TR><TR><TD>2011</TD><TD>111</TD><TD>$60.000</TD><TD>$120.000</TD><TD>50%</TD></TR><TR><TD>2012</TD><TD>111</TD><TD>$33.000</TD><TD>$110.000</TD><TD>30%</TD></TR></TBODY></TABLE><P></P><P>Thanks!</P></BODY></HTML> Tue, 06 Nov 2012 17:23:06 GMT 2012-11-06T17:23:06Z Max Amount Supplier https://community.qlik.com/t5/QlikView/Max-Amount-Supplier/m-p/408443#M151900 <HTML><HEAD></HEAD><BODY><P>Hi, How can I create a variable that bring the supplier ID with maximum amount in any period selected?</P><P></P><P>I need to compare the amount of each provider on the most participation has.</P><P></P><P>Example:</P><P>Max Amount Supplier</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="91" style="width: 286px; border: 1px solid #000000; height: 81px;" width="284"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Year</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Amount</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID_Supplier</STRONG></SPAN></TH></TR><TR><TD>2010</TD><TD>$100.000</TD><TD>123</TD></TR><TR><TD>2011</TD><TD>$120.000</TD><TD>444</TD></TR><TR><TD>2012</TD><TD>$110.000</TD><TD>999</TD></TR></TBODY></TABLE><P></P><P></P><P>After this I may have to make a table like this:</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="153" style="width: 496px; border: 1px solid rgb(0, 0, 0); height: 152px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Year</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID_Supplier</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Amount</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Amount_Max_Supplier</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Amount / <STRONG style="color: #ffffff; text-align: -webkit-center; background-color: #6690bc;">Amount_Max_Supplier</STRONG></STRONG></SPAN></TH></TR><TR><TD>2010</TD><TD>111</TD><TD>$20.000</TD><TD>$100.000</TD><TD>20%</TD></TR><TR><TD>2011</TD><TD>111</TD><TD>$60.000</TD><TD>$120.000</TD><TD>50%</TD></TR><TR><TD>2012</TD><TD>111</TD><TD>$33.000</TD><TD>$110.000</TD><TD>30%</TD></TR></TBODY></TABLE><P></P><P>Thanks!</P></BODY></HTML> Tue, 06 Nov 2012 17:23:06 GMT https://community.qlik.com/t5/QlikView/Max-Amount-Supplier/m-p/408443#M151900 2012-11-06T17:23:06Z Re: Max Amount Supplier https://community.qlik.com/t5/QlikView/Max-Amount-Supplier/m-p/408444#M151901 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>=FirstSortedValue(ID_Supplier, Amount)</P></BODY></HTML> Tue, 06 Nov 2012 18:04:01 GMT https://community.qlik.com/t5/QlikView/Max-Amount-Supplier/m-p/408444#M151901 whiteline 2012-11-06T18:04:01Z