topic Re: Firstsorted value and its count in the same table in QlikView https://community.qlik.com/t5/QlikView/Firstsorted-value-and-its-count-in-the-same-table/m-p/1247442#M850267 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Max(Aggr(Count(ID), Country, city_name)</STRONG></P></BODY></HTML> Tue, 21 Mar 2017 08:30:16 GMT sunny_talwar 2017-03-21T08:30:16Z Firstsorted value and its count in the same table https://community.qlik.com/t5/QlikView/Firstsorted-value-and-its-count-in-the-same-table/m-p/1247441#M850266 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>Could someone please help me. As i am trying to get the firstsorted value for each dimensions and use the firstsorted value to count no of IDs.</P><P></P><P>For example:</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">Country</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Top City</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Customers at Top City</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Total Customers</TH></TR><TR><TD style="padding: 2px;">Australia</TD><TD style="padding: 2px;">Sydney</TD><TD style="padding: 2px;">1200</TD><TD style="padding: 2px;">2000</TD></TR><TR><TD style="padding: 2px;">America</TD><TD style="padding: 2px;">New York</TD><TD style="padding: 2px;">1400</TD><TD style="padding: 2px;">3000</TD></TR></TBODY></TABLE><P></P><P></P><P>I got Top City using First sorted value =</P><P>For example: FirstSortedValue(city_name, (-(Aggr(count(ID), Country, city_name))))</P><P></P><P>but i want to calculate the Customers at that City by using above expression, as i cant use If condition as we have many countries.</P><P></P><P>Thanks in advance.</P><P></P><P>Karthik</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Firstsorted-value-and-its-count-in-the-same-table/m-p/1247441#M850266 karthikdaibala 2020-11-25T16:16:04Z Re: Firstsorted value and its count in the same table https://community.qlik.com/t5/QlikView/Firstsorted-value-and-its-count-in-the-same-table/m-p/1247442#M850267 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Max(Aggr(Count(ID), Country, city_name)</STRONG></P></BODY></HTML> Tue, 21 Mar 2017 08:30:16 GMT https://community.qlik.com/t5/QlikView/Firstsorted-value-and-its-count-in-the-same-table/m-p/1247442#M850267 sunny_talwar 2017-03-21T08:30:16Z