Discussion board where members can get started with QlikView.
Hi, I have a problem with my fixed report.
I have made a report which adds more than one page if needed. The problem is that I get the total amount both on page one and page two.
This is page one...
How can I do so I only get the total amount on the last page?
It' the stright table bheavior.
I've solved this with a little work around...may be usefull also for you.
I create two tables:
- One that doesn't shows total line and that is splitted in several pages.
- A second table that showes only the totals and I placed it in the appendix page section.
By this way I avoided the problem you described, but you have to mantain two tables instead of one.
How do I make a table that only showes the total?
You simply design a table with a dimension that summarize the dimensions in your orginal table.
Original table -> City | Expression
Total Table -> Nation | Expression
The total table re-compute the same expression that simply is the National total as sum of the cities values.