Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

Subtotal of Top X Records

Wondering if anyone knows how to add a row of subtotals to this chart to subtotal the Top 10?  There are more columns but this should give you the idea:

I want to subtotal the numbers for the actual Top 10 and (ideally) not have the Remainder show as #9 when they are ranked.

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.

Any help would be appreciated.

1 Reply
isingh30
Valued Contributor

Re: Subtotal of Top X Records

In presentation  click on  Show partial sums. Please include an expression for first 10 records. If it's not working then kindly share the data or app.

Thank you!