Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sort stacked bar chart by the largest customer

Hi, I have a stacked bar chart with sales divided by customer and I want the bar chart to be sorted by the largest customer on bottom from an accumulated stand point. Months are on the x-axis, so for example customer A has the greatest proportion of revenues up to April, but in April Customer B has the greatest revenues for only that month. However, customer A should be on the bottom because it has the greatest accumulated revenues.

How do I go about sorting the bar charts by accumulation?

Thanks in advance,

Glen

1 Reply
martin59
Specialist II
Specialist II

Hello Glen,

You have to sort your chart by Month (Numeric - ascending) and Customer by Expression using :

aggr(sum(Revenue),Customer)


Martin