topic Re: Top N customers Sales in App Development

Top N customers Sales

kmmqlick — Mon, 13 Dec 2021 13:04:51 GMT

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 — Mon, 13 Dec 2021 13:24:04 GMT

Hi,

Refer following link :

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

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

Regards

Vikas

kmmqlick — Mon, 13 Dec 2021 14:53:56 GMT

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 — Tue, 14 Dec 2021 12:46:00 GMT

Hey, try this:

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

No filters were applied to the sample data you provided:

kmmqlick — Tue, 14 Dec 2021 15:10:49 GMT

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