topic Report Editor in QlikView

Report Editor

Mon, 06 Dec 2010 10:50:13 GMT

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?

Thanks

/Markus

Anonymous — Mon, 06 Dec 2010 12:07:15 GMT

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

Mon, 06 Dec 2010 15:29:50 GMT

Thanks,

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

Markus

Anonymous — Mon, 06 Dec 2010 15:54:07 GMT

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