Top N customers Sales

[kmmqlick]

Hi team,

Thanks for you help in advance. I am facing issue with Top 3, Top 5 customers sales issue.

I am using a bar chart to show sum sales. Dim: Period , Measure: sum(Sales) 

Now default i want to show all customers sum of sales. But the issue is how to get sum sales of Top 3 customers and Top 5 customers in bar chart.

could you please suggest me how to write the expression.

i tried sum({<Customer={"=Rank(Sum(Sales),4)<=3"}>}Sales) -- > Not Getting Correct no's 

sample date and QVF files are attached.

Regards,

kmm

[vikasmahajan]

Hi,

Refer following link :

community.qlik.com/t5/New-to-Qlik-Sense/Top-N-Filter-Pane/td-p/1218141

or 

=Aggr(If(Rank(Sum(Sales), 1, 0) <= 5, Customer), Customer)

Regards

Vikas

[kmmqlick]

Hi Vikasmahajan,

Thanks for your reply. But my requirement is different. 

My dimensions are Period and Sum(Sales). I want sales customer wise. sum of sales in all quarters of top 3 customers.

I think  i need to add something in expression with set analysis.

Regards,

KMM

[RsQK]

Hey, try this:

SUM({<Customer={"=RANK(SUM(TOTAL <Customer> Sales),4)<=3"}>}Sales)

No filters were applied to the sample data you provided:

[kmmqlick]

Hi RsQk,

Thanks for your reply, But not giving correct numbers in bar chart (My bar chart Dim: Period)

once again thanks for your help

Regards,

kmm