topic Re: Member wise top Vendor List in QlikView https://community.qlik.com/t5/QlikView/Member-wise-top-Vendor-List/m-p/708846#M255377 <HTML><HEAD></HEAD><BODY><P>Thanks Shruthi..</P></BODY></HTML> Mon, 13 Oct 2014 06:15:24 GMT 2014-10-13T06:15:24Z Member wise top Vendor List https://community.qlik.com/t5/QlikView/Member-wise-top-Vendor-List/m-p/708844#M255375 <HTML><HEAD></HEAD><BODY><P>Hi , i have a table which have Member, Vendor wise Orders information like Below: </P><P></P><TABLE><TBODY><TR><TD>Date</TD><TD>MemberId</TD><TD>VendorId</TD><TD>Orders</TD></TR><TR><TD>1/1/2014</TD><TD>10</TD><TD>A</TD><TD>100</TD></TR><TR><TD>1/1/2014</TD><TD>10</TD><TD>B</TD><TD>200</TD></TR><TR><TD>2/1/2014</TD><TD>20</TD><TD>A</TD><TD>100</TD></TR><TR><TD>2/1/2014</TD><TD>10</TD><TD>C</TD><TD>300</TD></TR><TR><TD>2/1/2014</TD><TD>30</TD><TD>C</TD><TD>100</TD></TR><TR><TD>2/2/2014</TD><TD>20</TD><TD>B</TD><TD>400</TD></TR><TR><TD>2/3/2014</TD><TD>30</TD><TD>A</TD><TD>200</TD></TR></TBODY></TABLE><P></P><P></P><P>i want to know memberwise top Vendor like :</P><P></P><TABLE><TBODY><TR><TD>MemberId</TD><TD>Top Vendor</TD></TR><TR><TD>10</TD><TD>C</TD></TR><TR><TD>20</TD><TD>B</TD></TR><TR><TD>30</TD><TD>A</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 13 Oct 2014 06:04:13 GMT https://community.qlik.com/t5/QlikView/Member-wise-top-Vendor-List/m-p/708844#M255375 2014-10-13T06:04:13Z Re: Member wise top Vendor List https://community.qlik.com/t5/QlikView/Member-wise-top-Vendor-List/m-p/708845#M255376 <HTML><HEAD></HEAD><BODY><P>you can create a straight table, with memberid and vendorid in dimensions. add expression sum(orders).</P><P>In dimension limits select Vendorid and select larget 1 in the dimension value.</P><P>you will get top vendors listed for each memberid.</P></BODY></HTML> Mon, 13 Oct 2014 06:08:52 GMT https://community.qlik.com/t5/QlikView/Member-wise-top-Vendor-List/m-p/708845#M255376 2014-10-13T06:08:52Z Re: Member wise top Vendor List https://community.qlik.com/t5/QlikView/Member-wise-top-Vendor-List/m-p/708846#M255377 <HTML><HEAD></HEAD><BODY><P>Thanks Shruthi..</P></BODY></HTML> Mon, 13 Oct 2014 06:15:24 GMT https://community.qlik.com/t5/QlikView/Member-wise-top-Vendor-List/m-p/708846#M255377 2014-10-13T06:15:24Z