topic Re: Help regarding Advanced aggregation in QlikView https://community.qlik.com/t5/QlikView/Help-regarding-Advanced-aggregation/m-p/509487#M555753 <HTML><HEAD></HEAD><BODY><P>Create a chart with dimension Country and two expressions:</P><P></P><P>=FirstSortedValue(DISTINCT [Sales Person], -Sales)</P><P></P><P>=max(Sales)</P></BODY></HTML> Mon, 22 Jul 2013 15:49:01 GMT swuehl 2013-07-22T15:49:01Z Help regarding Advanced aggregation https://community.qlik.com/t5/QlikView/Help-regarding-Advanced-aggregation/m-p/509486#M555752 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P></P><P>I need small help regarding advanced aggregation.</P><P>I've data like this.</P><TABLE border="0" cellpadding="0" cellspacing="0" width="213"><TBODY><TR><TD height="20" width="64">Country</TD><TD width="85">Sales Person</TD><TD width="64">Sales</TD></TR><TR><TD height="20">India</TD><TD>Surendra</TD><TD align="right">2000</TD></TR><TR><TD height="20">India</TD><TD>Pawan</TD><TD align="right">1000</TD></TR><TR><TD height="20">India</TD><TD>Suresh</TD><TD align="right">5000</TD></TR><TR><TD height="20">USA</TD><TD>Ramesh</TD><TD align="right">3000</TD></TR><TR><TD height="20">USA</TD><TD>Girish</TD><TD align="right">20000</TD></TR><TR><TD height="20">USA</TD><TD>Surendra</TD><TD align="right">1890</TD></TR><TR><TD height="20">USA</TD><TD>Pawan</TD><TD align="right">5349</TD></TR><TR><TD height="20">UK</TD><TD>Kiran</TD><TD align="right">7890</TD></TR><TR><TD height="20">UK</TD><TD>Suresh</TD><TD align="right">9890</TD></TR><TR><TD height="20">UK</TD><TD>Ramesh</TD><TD align="right">3234</TD></TR><TR><TD height="20">UK</TD><TD>Girish</TD><TD align="right">5098</TD></TR></TBODY></TABLE><P>All I want to show is the Sales Person who has done the maximum sales across each country.</P><P>The result should look like this.</P><TABLE border="0" cellpadding="0" cellspacing="0" width="192"><TBODY><TR><TD height="20" width="64">Country</TD><TD width="64">Sales Person</TD><TD width="64">Sales</TD></TR><TR><TD height="20">India</TD><TD>Suresh</TD><TD align="right">5000</TD></TR><TR><TD height="20">USA</TD><TD>Girish</TD><TD align="right">20000</TD></TR><TR><TD height="20">UK</TD><TD>Suresh</TD><TD align="right">9890</TD></TR></TBODY></TABLE><P></P><P>Kindly help me with the expression.</P><P></P><P></P><P>Thanks,</P><P>Surendra</P></BODY></HTML> Mon, 22 Jul 2013 15:37:51 GMT https://community.qlik.com/t5/QlikView/Help-regarding-Advanced-aggregation/m-p/509486#M555752 2013-07-22T15:37:51Z Re: Help regarding Advanced aggregation https://community.qlik.com/t5/QlikView/Help-regarding-Advanced-aggregation/m-p/509487#M555753 <HTML><HEAD></HEAD><BODY><P>Create a chart with dimension Country and two expressions:</P><P></P><P>=FirstSortedValue(DISTINCT [Sales Person], -Sales)</P><P></P><P>=max(Sales)</P></BODY></HTML> Mon, 22 Jul 2013 15:49:01 GMT https://community.qlik.com/t5/QlikView/Help-regarding-Advanced-aggregation/m-p/509487#M555753 swuehl 2013-07-22T15:49:01Z Re: Help regarding Advanced aggregation https://community.qlik.com/t5/QlikView/Help-regarding-Advanced-aggregation/m-p/509488#M555754 <HTML><HEAD></HEAD><BODY><P>Thanks a lot swuehl</P></BODY></HTML> Mon, 22 Jul 2013 15:54:15 GMT https://community.qlik.com/t5/QlikView/Help-regarding-Advanced-aggregation/m-p/509488#M555754 2013-07-22T15:54:15Z