How to rank a simple selection - Page 2 - Qlik Community

Report Inappropriate Content · ‎2014-08-23

I'm sure this is a simple question for the experienced ones ... but as a bloody beginner to QV it's costing me an afternoon without success.

From the data in my (simplified) table

I want to plot a chart for each <customer> (i.e. customer in listbox) and the dimension <month>.

The data in the chart should be sum(amount) and the rank of the (selected) customer (by sum(amount))

However I put the expression, I either get the rankings of all months or no result.

I'm sure I have to work with AGGR but wherever I place it seems to be wrong.

Can anybody help please.

Report Inappropriate Content · ‎2014-09-23

I have managed to get the rankings in the chart below.

Now I would like to modify the chart that only the line for customer A is visible. I can't use the listbox object to select the customer as this would change the ranking result, i.e. I want the ranking to be calculated across all customers.

Which setting do I have to change to make only one line visible?