Top 3 as Lines on Combo Chart

[cchristenson2]

Hi, 

Looking to show the totals as a bar and then show the top 3 as lines - anyone have any ideas on how to do this in Qlik Sense?

I can get it to work in a table with this code, if(rank(aggr(count(RECORD_ID),SYSTM_SHRT) )<=3,count(RECORD_ID)) see table below:

Here is what I would like to see in the chart, but to be dynamic and update as users make selections. In qlikview you can add two dimensions to pull off something like this, but in qlik sense you can only add alternate dimensions:

[dwforest]

Did you try using that formula as a Reference line?

[cchristenson2]

I did, does not work. Good idea though.