Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hey, try this:
SUM({<Customer={"=RANK(SUM(TOTAL <Customer> Sales),4)<=3"}>}Sales)
No filters were applied to the sample data you provided:
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