Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal will move to Qlik Community Oct 4. Temporary case outage Oct 3. READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pratik_advani
Contributor
Contributor

Best customer, best product and best salesman KPI

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.

4 Replies
sibideepak
Creator II
Creator II

Here Your solution has been attached ...

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

pratik_advani
Contributor
Contributor
Author

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
MVP
MVP

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
Creator II
Creator II

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.