Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

SALES REPORT: TOP CUSTOMERS

hey evryone short questiion regarding a sale report , how do i present my top customers and my wickest customers?

1 Solution

Accepted Solutions
Employee
Employee

Re: SALES REPORT: TOP CUSTOMERS

Have a look a the following. 2 horizontal bars. One with top 5 and other with bottom 5

i made the min/max of the axis the same.

The measure is sum(Sales) so the max is the maximum value by customer (i have country)

Max( total aggr( sum(Sales), country) )  

and the min is similar

Max( total aggr( sum(Sales), country) )  


i also moved the axis on the top bar to the top and changed the colors


I think its a decent approach to show the top/bottom 5

Capture.PNG

Capture2.PNG

12 Replies
reddys310
Honored Contributor II

Re: SALES REPORT: TOP CUSTOMERS

Hi Jhonatan,

A scatter plot would be the best way to show it. It would be very easy to pic the outlays.

You can even go with colour coding (RAG status) to give a better visual appearance.

Employee
Employee

Re: SALES REPORT: TOP CUSTOMERS

Have a look a the following. 2 horizontal bars. One with top 5 and other with bottom 5

i made the min/max of the axis the same.

The measure is sum(Sales) so the max is the maximum value by customer (i have country)

Max( total aggr( sum(Sales), country) )  

and the min is similar

Max( total aggr( sum(Sales), country) )  


i also moved the axis on the top bar to the top and changed the colors


I think its a decent approach to show the top/bottom 5

Capture.PNG

Capture2.PNG

Not applicable

Re: SALES REPORT: TOP CUSTOMERS

i did it and got this....report.PNG

Not applicable

Re: SALES REPORT: TOP CUSTOMERS

Max( total aggr( NIS_TOTPRICE, CUST_CUSTNAME) )

Employee
Employee

Re: SALES REPORT: TOP CUSTOMERS

The expression is syntactically.incorrect. The first argument for the aggr () function is a chart aggregation function like sum()

Example:

Max( total aggr( sum(NIS_TOTPRICE), CUST_CUSTNAME))

Not applicable

Re: SALES REPORT: TOP CUSTOMERS

i don't see where are u placing this expression....

Employee
Employee

Re: SALES REPORT: TOP CUSTOMERS

Take a look at the bottom right part of my 2nd screenshot above. I'm.using it to.define a min or max on the X axis scale. That way the scales for both apps line up and it's useful to see how far apart the.top.customers.are.from the bottom.customers.

Not applicable

Re: SALES REPORT: TOP CUSTOMERS

Hey i used your suggestion and i am getting a table with 10 customers,

but still no getting the top/lowest ....

1.PNG

2.PNG

Employee
Employee

Re: SALES REPORT: TOP CUSTOMERS

It LOOKS like you are getting both top 10 and bottom 10 in the tables. Perhaps you want to hit the 'Sorting' property on the right to ensure you are sorting by ILS Total ?  To me it looks like only the sort is missing.