topic Pivot table page break in QlikView

Pivot table page break

guyvermeiren — Mon, 14 Jun 2010 14:50:25 GMT

Hello,

I have a report where I want to print a pivot table on two pages and one of my dimensions is in the columns.

Is it possible to set a pagebreak for this dimension. (I already tried to use 'Conditional break' without result).

Thanks.

Kind regards,

Guy

Pivot table page break

fernandotoledo — Mon, 14 Jun 2010 15:01:53 GMT

The breaks in pivot table works other way, where you say how QV deals with the change of the dimensions.

I Don´t lknow how your report looks like but, if it has a fixed number of rows you can create a calculated dimension grouping the rows in two parts, then use the forced break.

The calculated Dimension (Page) formula should be " if([Report Line]<=3, '1' ,'2')

The result is something like:

BEFORE


Report Line Value
1 1000
2 2000
3 3000
4 4000
5 5000
6 6000

AFTER


Page Report Line Value
1 1 1000
1 2 2000
1 3 3000
2 4 4000
2 5 5000
2 6 6000

Pivot table page break

guyvermeiren — Mon, 14 Jun 2010 15:24:15 GMT

Mr Fernando,

Thanks, but I would like to apply this page break to the columns, this means for example dimensions values 1 to 7 (first 7 colums) on page 1 and values 7 to 12 (columns 7 to 12) on page 2. Within each dimesion value I have results for 3 expressions ( total resultcolums:36).

Kind regards,

Guy

Pivot table page break

fernandotoledo — Mon, 14 Jun 2010 15:47:42 GMT

Ok, page breaks only works for rows.

But you can create a calculated dimension showing only some values in the dimension you use as column. Then you can either have 3 charts or a field (like the previous "Page" one) that maps your columns in pages.

To print this create a Document Report with the 3 charts or with One chart that loops through the Page field.

hope it helps this time

Fernando

Pivot table page break

guyvermeiren — Tue, 15 Jun 2010 08:53:01 GMT

Fernando,

OK, I managed to create the calculated dimension and named it "Page" but when I'm trying to set up a report with a loop I can't find my calculated dimension-field in the list that says that that's the field to loop through.

Kin,d regards,

Guy