Best customer, best product and best salesman KPI

[Anonymous]

Hi, can anyone tell me how to display the best salesman by region and by product as a KPI. I have attached my QVW file. Also tell me how to display best customer and best product.

[sibideepak]

Here Your solution has been attached ...

You can calculate the best one using quantity or sales amount its according to your requirement.

[Anonymous]

I am using personal edition of qlikview and not able to open your file. Can you tell me which expression did you use to calculate the KPI in dashboard.

I am not able to display the best customer, best salesman and best product as a KPI in dashboard. The best salesman should be for each customer, region as well as product. The same concept applies for best customer and best product.

[tresesco]

There are online demo applications, download it; you will find some very good samples helpful. Qlik Demos: See QlikView in Action | Demo.QlikView.Com

[sibideepak]

Best sales man,

=FirstSortedValue(SalesManName,-Aggr(sum(Quantity),CustomerID,CountryName))

best customer,

=FirstSortedValue(CustomerName,-Aggr(sum(Quantity),CountryName,ItemID))

best product,

=FirstSortedValue(Itemname_1,-Aggr(sum([Sales with Discount]),ItemID))

you can use quantity or sales amount as your measure .. its according to your requirement . I prefer sales amount.

And you can aggregate the values for wish.