Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Employee
Employee

Bar Chart Where each bar shows the Top N Customers Sales

This seems that it would be a fairly common requirement.  But I can't find any examples.

What I want to end up with is a bar for each quarter.  Each bar represents the total sales from the top 100 customers in that quarter.  The Top 100 customers will change from quarter to quarter.

I have tried many versions of expressions and nothing works when displaying all quarters in the bar chart.  I only get the correct total when I filter on a single quarter.  It seems like it is unable to determine the Top 100 customers per quarter.

Any ideas would be greatly appreciated.  Even a totally different approach like maybe assigning the rank per quarter in the load script.

Thanks

3 Replies
Claudiu_Anghelescu
Contributor III

Re: Bar Chart Where each bar shows the Top N Customers Sales

Try using ValueList()

To help community find solutions, please don't forget to mark as correct.
MVP & Luminary
MVP & Luminary

Re: Bar Chart Where each bar shows the Top N Customers Sales

I would think something like:

if(rank(sum(Sales) <= 100, Sum(Sales))

-Rob

Employee
Employee

Re: Bar Chart Where each bar shows the Top N Customers Sales

Thanks Rob.  I think this would assume that the dimension is customer.  In my case the dimension is quarter and I want the top 100 customers for each quarter.