Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Report Editor

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...

error loading image

How can I do so I only get the total amount on the last page?

Thanks

/Markus

3 Replies
matteofioroni
Contributor

Report Editor

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.

regards,

Matteo

Not applicable

Report Editor

Thanks,

How do I make a table that only showes the total?

Markus

matteofioroni
Contributor

Report Editor

You simply design a table with a dimension that summarize the dimensions in your orginal table.

E.g.

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.

Matteo

Community Browser