https://community.qlik.com/t5/App-Development/Top-3-as-Lines-on-Combo-Chart/m-p/1522786#M37498 Did you try using that formula as a Reference line? Thu, 20 Dec 2018 00:49:24 GMT dwforest 2018-12-20T00:49:24Z https://community.qlik.com/t5/App-Development/Top-3-as-Lines-on-Combo-Chart/m-p/1515755#M36733 <P>Hi,&nbsp;</P><P>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?</P><P>I can get it to work in a table with this code,&nbsp;<STRONG>if(rank(aggr(count(RECORD_ID),SYSTM_SHRT) )&lt;=3,count(RECORD_ID))</STRONG>&nbsp;see table below:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Table_Top_3.png" style="width: 472px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/1502i7CAC6A5E392340CE/image-size/large?v=v2&amp;px=999" role="button" title="Table_Top_3.png" alt="Table_Top_3.png" /></span></P><P>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:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Combo_Top3.png" style="width: 982px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/1503iEE71BAEA4FA0EDD3/image-size/large?v=v2&amp;px=999" role="button" title="Combo_Top3.png" alt="Combo_Top3.png" /></span></P> Mon, 03 Dec 2018 16:19:04 GMT https://community.qlik.com/t5/App-Development/Top-3-as-Lines-on-Combo-Chart/m-p/1515755#M36733 cchristenson2 2018-12-03T16:19:04Z https://community.qlik.com/t5/App-Development/Top-3-as-Lines-on-Combo-Chart/m-p/1522786#M37498 Did you try using that formula as a Reference line? Thu, 20 Dec 2018 00:49:24 GMT https://community.qlik.com/t5/App-Development/Top-3-as-Lines-on-Combo-Chart/m-p/1522786#M37498 dwforest 2018-12-20T00:49:24Z https://community.qlik.com/t5/App-Development/Top-3-as-Lines-on-Combo-Chart/m-p/1559291#M40735 <P>I did, does not work. Good idea though.&nbsp;</P> Wed, 20 Mar 2019 21:14:38 GMT https://community.qlik.com/t5/App-Development/Top-3-as-Lines-on-Combo-Chart/m-p/1559291#M40735 cchristenson2 2019-03-20T21:14:38Z