topic Re: Issue in set analysis in QlikView https://community.qlik.com/t5/QlikView/Issue-in-set-analysis/m-p/779739#M276337 <HTML><HEAD></HEAD><BODY><P>Use Rank function and Max may give you the solutions.</P><P></P><P>Ex: Max(sum(Tradevalue),Vendorcity) like this.</P></BODY></HTML> Tue, 24 Feb 2015 11:40:31 GMT hariprasadqv 2015-02-24T11:40:31Z Issue in set analysis https://community.qlik.com/t5/QlikView/Issue-in-set-analysis/m-p/779738#M276336 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>My requirement is to find CITYwise,Top&nbsp; VENDORSHORTNAME according to sum(trade_value) and then count of LOCATIONID</P><P></P><P>i have create a Variable with following expression : vTopVendorCitywise: FirstSortedValue(VENDORSHORTNAME,-aggr(Sum(TRADE_VALUE),VENDORSHORTNAME,CITY))</P><P></P><P>below is the expression in using in Straight table with Dimension CIty <IMG alt="Citywise_TopVendor_traders.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/78948_Citywise_TopVendor_traders.png" style="height: 166px; width: 620px;" /></P><P>=Count( DISTINCT {&lt;VENDORSHORTNAME={'$(=vTopVendorCitywise)'}&gt;} LOCATIONID)</P><P></P><P>Please let me know what wrong i am doing in this</P></BODY></HTML> Tue, 24 Feb 2015 11:25:43 GMT https://community.qlik.com/t5/QlikView/Issue-in-set-analysis/m-p/779738#M276336 2015-02-24T11:25:43Z Re: Issue in set analysis https://community.qlik.com/t5/QlikView/Issue-in-set-analysis/m-p/779739#M276337 <HTML><HEAD></HEAD><BODY><P>Use Rank function and Max may give you the solutions.</P><P></P><P>Ex: Max(sum(Tradevalue),Vendorcity) like this.</P></BODY></HTML> Tue, 24 Feb 2015 11:40:31 GMT https://community.qlik.com/t5/QlikView/Issue-in-set-analysis/m-p/779739#M276337 hariprasadqv 2015-02-24T11:40:31Z