topic Re: Top 2 Clients for each Group in QlikView https://community.qlik.com/t5/QlikView/Top-2-Clients-for-each-Group/m-p/699851#M1080044 <HTML><HEAD></HEAD><BODY><P>Hi <A href="https://community.qlik.com/qlik-users/158932">bhawna gupta</A>,</P><P></P><P>Have a look at the attachment, I think it's what you are looking for.</P><P></P><P>Kind Regards,</P><P><BR />Cesar</P></BODY></HTML> Wed, 02 Jul 2014 15:51:06 GMT cesaraccardi 2014-07-02T15:51:06Z Top 2 Clients for each Group https://community.qlik.com/t5/QlikView/Top-2-Clients-for-each-Group/m-p/699850#M1080043 <HTML><HEAD></HEAD><BODY><P>Hello friends,</P><P>I have following table</P><TABLE border="1" class="jiveBorder" height="200" style="border: 1px solid rgb(0, 0, 0); width: 253px; height: 34px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Group<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Client</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sales</TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Ca1</TD><TD style="padding: 2px;">500</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Ca2</TD><TD style="padding: 2px;">400</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Ca3</TD><TD style="padding: 2px;">600</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Ca4</TD><TD style="padding: 2px;">200</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"><P>Cb1</P></TD><TD style="padding: 2px;">300</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">Cb2</TD><TD style="padding: 2px;">250</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">Cb3</TD><TD style="padding: 2px;">350</TD></TR></TBODY></TABLE><P>Now my requirement is to find top 2 client for each group by sales,the output table must be like</P><TABLE border="1" class="jiveBorder" height="125" style="border: 1px solid rgb(0, 0, 0); width: 234px; height: 88px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Group</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Client</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Ca3</TD><TD style="padding: 2px;">600</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Ca1</TD><TD style="padding: 2px;">500</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">Cb3</TD><TD style="padding: 2px;">350</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">Cb1</TD><TD style="padding: 2px;">300</TD></TR></TBODY></TABLE><P>Thanks in advance for everyone's idea and reply..</P></BODY></HTML> Wed, 02 Jul 2014 15:07:19 GMT https://community.qlik.com/t5/QlikView/Top-2-Clients-for-each-Group/m-p/699850#M1080043 2014-07-02T15:07:19Z Re: Top 2 Clients for each Group https://community.qlik.com/t5/QlikView/Top-2-Clients-for-each-Group/m-p/699851#M1080044 <HTML><HEAD></HEAD><BODY><P>Hi <A href="https://community.qlik.com/qlik-users/158932">bhawna gupta</A>,</P><P></P><P>Have a look at the attachment, I think it's what you are looking for.</P><P></P><P>Kind Regards,</P><P><BR />Cesar</P></BODY></HTML> Wed, 02 Jul 2014 15:51:06 GMT https://community.qlik.com/t5/QlikView/Top-2-Clients-for-each-Group/m-p/699851#M1080044 cesaraccardi 2014-07-02T15:51:06Z