Solved: Re: TOP5 Customers based on sales - Qlik Community

Anonymous · ‎2017-10-20

I want to display Top5 customers based on sales in straight table by using expression.

Only Top5 customers (Based on sales) should display, remaining customers should not display.

Please drop the solution here only as i can't open QVW file in my machine.

passionate · ‎2017-10-20

Also check suppress null option

alexandros17 · ‎2017-10-20

Suppose you have this table:

Invoice with Customer and Amount Field

Every Database has an instruction to exctract the top n values (There are "Limit" or "TOP" Keawords for instance)

a query like this one:

select customer, sum(Amount) as somma from invoice group by customer order by somma desc limit 5

extract the first 50 then do an inner join of this one with the complete table of invoice (invoice is obviously for example)

pradosh_thakur · ‎2017-10-20

IF want to do it in dashboard itself

1: use Rank function to filter out first 5 then filter

or

2: sort it by sales descending . use if(rowno()<=5,sum(sales)) in expression ans suppress null

or

3: dimesnsion limits -> show top 5 values

regards

Pradosh

Learning never stops.

Mark_Little · ‎2017-10-20

Hi.

If you are using QlikView.

Create your Straight table, with the expressions SUM(Sales).

On the Dimension Limits,

set up as pictures below.

Mark

Anonymous · ‎2017-10-20

Hi,

If I use if(rowno()<=5,sum(sales)), the result is showing like below.

pradosh_thakur · ‎2017-10-20

not like this ..share the app if possible .

regards

Pradosh

Learning never stops.

Mark_Little · ‎2017-10-20

Here is a example attached.

Anonymous · ‎2017-10-20

Please provide the correct expression and steps how to achieve TOP5 Customers.

pradosh_thakur · ‎2017-10-20

please find the attached

regards

Pradosh

Learning never stops.

pradosh_thakur · ‎2017-10-20

1: Method is already described by MARK

2: IN THE SORT tab use rank(sum(sales))> 0 in customer sorting

regards

Pradosh

Learning never stops.