topic Error in set analysis in QlikView

Error in set analysis

Fri, 16 Nov 2012 14:30:42 GMT

Hi Guys,

Please check this calculation and let me know where the problem is. I want to get the name of the first customer is sales and show its sales.

Thanks.

=(sum({$<CUSTOMER={=aggr(if(rank(sum(SALES))=1 ,CUSTOMER),'' )}>}SALES))

MayilVahanan — Fri, 16 Nov 2012 14:37:31 GMT

Try like this

=sum({<Customer = {"= rank(Sum(Sales))=1"}>}Sales)

Hope it helps

Fri, 16 Nov 2012 14:45:52 GMT

Thanks , it worked...........