topic Re: Top 2 company over past 3 years and 2 Years in QlikView https://community.qlik.com/t5/QlikView/Top-2-company-over-past-3-years-and-2-Years/m-p/639352#M1089427 <HTML><HEAD></HEAD><BODY><P>Does that mean, you want Top 2 vendor for each year? Your question is not clear. Please explain</P></BODY></HTML> Wed, 04 Jun 2014 13:40:19 GMT 2014-06-04T13:40:19Z Top 2 company over past 3 years and 2 Years https://community.qlik.com/t5/QlikView/Top-2-company-over-past-3-years-and-2-Years/m-p/639351#M1089426 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P>I have a table with following Field</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"><STRONG>Vendor</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></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">year</TH></TR><TR><TD style="padding: 2px;">AB</TD><TD style="padding: 2px;">P1</TD><TD style="padding: 2px;">2000</TD><TD style="padding: 2px;"><P>2001</P></TD></TR><TR><TD style="padding: 2px;">BC</TD><TD style="padding: 2px;">P2</TD><TD style="padding: 2px;">3000</TD><TD style="padding: 2px;">2002</TD></TR><TR><TD style="padding: 2px;"><P>CD</P></TD><TD style="padding: 2px;">P3</TD><TD style="padding: 2px;">4000</TD><TD style="padding: 2px;">2003</TD></TR><TR><TD style="padding: 2px;">DE</TD><TD style="padding: 2px;">P4</TD><TD style="padding: 2px;">4500</TD><TD style="padding: 2px;">2004</TD></TR><TR><TD style="padding: 2px;">EF</TD><TD style="padding: 2px;">P5</TD><TD style="padding: 2px;">2000</TD><TD style="padding: 2px;">2005</TD></TR></TBODY></TABLE><P>Then my query is to find Top 2 Vendor over 3 years,please help me out.. if anyone has any solution.</P></BODY></HTML> Wed, 04 Jun 2014 13:36:02 GMT https://community.qlik.com/t5/QlikView/Top-2-company-over-past-3-years-and-2-Years/m-p/639351#M1089426 2014-06-04T13:36:02Z Re: Top 2 company over past 3 years and 2 Years https://community.qlik.com/t5/QlikView/Top-2-company-over-past-3-years-and-2-Years/m-p/639352#M1089427 <HTML><HEAD></HEAD><BODY><P>Does that mean, you want Top 2 vendor for each year? Your question is not clear. Please explain</P></BODY></HTML> Wed, 04 Jun 2014 13:40:19 GMT https://community.qlik.com/t5/QlikView/Top-2-company-over-past-3-years-and-2-Years/m-p/639352#M1089427 2014-06-04T13:40:19Z Re: Top 2 company over past 3 years and 2 Years https://community.qlik.com/t5/QlikView/Top-2-company-over-past-3-years-and-2-Years/m-p/639353#M1089428 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>This is one way:</P><P></P><P>Top =Max(Aggr(Sum(Sales), Vendor, Year))</P><P>2nd =Max(Aggr(Sum(Sales), Vendor, Year), 2)</P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Wed, 04 Jun 2014 13:43:57 GMT https://community.qlik.com/t5/QlikView/Top-2-company-over-past-3-years-and-2-Years/m-p/639353#M1089428 jonathandienst 2014-06-04T13:43:57Z Re: Top 2 company over past 3 years and 2 Years https://community.qlik.com/t5/QlikView/Top-2-company-over-past-3-years-and-2-Years/m-p/639354#M1089429 <HTML><HEAD></HEAD><BODY><P>No I want top 2 vendor for over 3 Years,</P><P>and then in another table top 2 vendor for over 2 Years</P></BODY></HTML> Wed, 04 Jun 2014 13:44:31 GMT https://community.qlik.com/t5/QlikView/Top-2-company-over-past-3-years-and-2-Years/m-p/639354#M1089429 2014-06-04T13:44:31Z Re: Top 2 company over past 3 years and 2 Years https://community.qlik.com/t5/QlikView/Top-2-company-over-past-3-years-and-2-Years/m-p/639355#M1089430 <HTML><HEAD></HEAD><BODY><P>And this is another (eg in calc dimension):</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; =If(Rank(Aggr(Sum(Sales), Vendor, Year)) &lt;= 2, Vendor)</P></BODY></HTML> Wed, 04 Jun 2014 13:46:10 GMT https://community.qlik.com/t5/QlikView/Top-2-company-over-past-3-years-and-2-Years/m-p/639355#M1089430 jonathandienst 2014-06-04T13:46:10Z Re: Re: Top 2 company over past 3 years and 2 Years https://community.qlik.com/t5/QlikView/Top-2-company-over-past-3-years-and-2-Years/m-p/639356#M1089431 <HTML><HEAD></HEAD><BODY><P>Check the attachment if that helps.</P></BODY></HTML> Wed, 04 Jun 2014 13:49:03 GMT https://community.qlik.com/t5/QlikView/Top-2-company-over-past-3-years-and-2-Years/m-p/639356#M1089431 venkatg6759 2014-06-04T13:49:03Z Re: Top 2 company over past 3 years and 2 Years https://community.qlik.com/t5/QlikView/Top-2-company-over-past-3-years-and-2-Years/m-p/639357#M1089432 <HTML><HEAD></HEAD><BODY><P>I have used different personal edition could you please write the code here.. </P></BODY></HTML> Wed, 04 Jun 2014 14:17:54 GMT https://community.qlik.com/t5/QlikView/Top-2-company-over-past-3-years-and-2-Years/m-p/639357#M1089432 2014-06-04T14:17:54Z