Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show total only on last page of a multipage report?

Hi,

I'm making a report for PDF with one table in it.

This table goes over more than one page so I'm using multi page.

The problem I have now is the "total" sum which is now at the end of the table on EVER page.


I would like to have the "total" sum at the end of the table ONLY on the LAST page.

Is this possible?

(We are using the QlikView 11.20 SR9)

Thanks,

Vanessa

6 Replies
buzzy996
Master II
Master II

u can try,

Presentation-Totals-Totals on last row

Anonymous
Not applicable
Author

Hi

Properties >>Expresions>>Total Mode >>Total Expressions

and  Presentation >> Totals>>   you  select Totals on last rows

Not applicable
Author

There is no change in this report, it still shows the Total in each multi page

_armoco_
Partner - Creator II
Partner - Creator II

Hi,

Did you manage to solve this? I'm facing the same now. Any help would be much appreciated

_armoco_
Partner - Creator II
Partner - Creator II

Hi,

I managed to it by changing the chart to a pivot instead of a straight chart.

I don't think that its possible in a straight chart...not sure though.

So, change the chart to a pivot and tick show partial sums and we are ready to go!

mvanlutterveld
Partner - Creator II
Partner - Creator II

Hi,

A different approach: end the report with a summary page and calculate the totals in text objects