Display First Rank Only, in Chart

[donahuej]

I have been using the following in a Text Object to display the first ranked "Project_ID" by a metric "Maximum Annual..." to great success:

=only(aggr(if(rank(sum([Maximum Annual Opportunity (from Benchmark)]),4)=1,Project_ID), Project_ID))

I also use this in other text objects on the same sheet, to display that same Project_ID's volume (which is just a count of account numbers) as seen below:

=only(aggr(if(rank(sum([Maximum Annual Opportunity (from Benchmark)]),4)=1,count(DISTINCT(Acct_Num))), Project_ID))

Unfortunately, I don't know how to get this to work within a chart. Here's the expression and screen shot:

Chart Type: Line Chart

Dimension: "Zero Balance Month"

Expression: =only(aggr(if(rank(sum([Maximum Annual Opportunity (from Benchmark)]),4)=1,count(DISTINCT(Acct_Num))), Project_ID))

Screenshot: attached

As you can see, it is calculating a value, which is equal to the total volume. But I want that volume by Zero Balance Month in this chart. Any ideas?

[Brett_Bleess]

Jake, I would venture you are not getting much traction, as this one likely needs a QVW file for someone to be able to help better, as in general they will want to see the data model you have as well as the chart etc. in order to determine the proper make-up of the expression in the chart.  If you can attach a sample QVW with the gist of your situation that would work, but the actual app would be better.  If there is sensitive data in the app, you can use the Desktop Client Settings\Document Properties\Scrambling tab to scrambling sensitive fields, but be sure those are not a key to your expression etc., as that may make things a bit difficult to figure out...  

The only place I have otherwise is the following:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

https://community.qlik.com/t5/Qlik-Design-Blog/Pitfalls-of-the-Aggr-function/ba-p/1463275

There are some other hits on things, but I figured these may be the two best to start with, apologies if I have missed the gist of things.  My post will also kick things back up too, perhaps someone else will chime in as well.

Regards,
Brett