topic Re: Top Vendor Name from City in QlikView

Top Vendor Name from City

Wed, 10 Dec 2014 10:03:17 GMT

Dear All,

i want to get Citywise TOP Vendor name which i want to display on Table. i have written a set analysis as below. kindly check and let me know what wrong is there.

1.) getting the citywise, max vendor T/O information.

2.) getting the name of the Vendor from that max value.

=Only( {$<VENDORSHORTNAME={"=(sum( TRADE_VALUE)/vmaxDay))=MAX(AGGR((sum( TRADE_VALUE)/vmaxDay),CITY,VENDORSHORTNAME))"}>} VENDORSHORTNAME)

Thanks & Regards,

Jitendra

Re: Top Vendor Name from City

anbu1984 — Wed, 10 Dec 2014 10:12:03 GMT

Try FirstSortedValue(Vendor,-Aggr(Sum(Sales),Vendor,City))

Re: Top Vendor Name from City

Wed, 10 Dec 2014 10:12:29 GMT

by below mention syntax i am able to get top turnover

=MAX(AGGR((sum( TRADE_VALUE)),CITY,VENDORSHORTNAME))

Now i want to get the VENDORSHORTNAME from this. means what is the VENDORSHORTNAME of that max turnover

Re: Top Vendor Name from City

Wed, 10 Dec 2014 10:19:38 GMT

Thanks Anbu Cheliyan