topic Re: Subtotal of Top X Records in QlikView https://community.qlik.com/t5/QlikView/Subtotal-of-Top-X-Records/m-p/42919#M7225 <HTML><HEAD></HEAD><BODY><P>In presentation&nbsp; click on&nbsp; Show partial sums. Please include an expression for first 10 records. If it's not working then kindly share the data or app.</P><P></P><P>Thank you!</P></BODY></HTML> Fri, 02 Mar 2018 19:37:59 GMT isingh30 2018-03-02T19:37:59Z Subtotal of Top X Records https://community.qlik.com/t5/QlikView/Subtotal-of-Top-X-Records/m-p/42918#M7224 <HTML><HEAD></HEAD><BODY><P>Wondering if anyone knows how to add a row of subtotals to this chart to subtotal the Top 10?&nbsp; There are more columns but this should give you the idea:</P><P></P><P>I want to subtotal the numbers for the actual Top 10 and (ideally) not have the Remainder show as #9 when they are ranked.</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195195_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>I can move the totals to the bottom (they'd likely make way more sense there if the subtotals get added), but I cannot see any way to do this.</P><P></P><P>Any help would be appreciated.</P></BODY></HTML> Fri, 02 Mar 2018 18:56:34 GMT https://community.qlik.com/t5/QlikView/Subtotal-of-Top-X-Records/m-p/42918#M7224 raynac 2018-03-02T18:56:34Z Re: Subtotal of Top X Records https://community.qlik.com/t5/QlikView/Subtotal-of-Top-X-Records/m-p/42919#M7225 <HTML><HEAD></HEAD><BODY><P>In presentation&nbsp; click on&nbsp; Show partial sums. Please include an expression for first 10 records. If it's not working then kindly share the data or app.</P><P></P><P>Thank you!</P></BODY></HTML> Fri, 02 Mar 2018 19:37:59 GMT https://community.qlik.com/t5/QlikView/Subtotal-of-Top-X-Records/m-p/42919#M7225 isingh30 2018-03-02T19:37:59Z