Page Breaks in pivot table - Qlik Community

pavansonu99 · ‎2017-03-12

Hi ,

can some one help me in using page breaks in pivot or straight table.

devarasu07 · ‎2017-03-12

Hi Pavan,

Maybe this discussion can help you

Tks,Deva

vishsaggi · ‎2017-03-12

What you mean by page breaks? You mean row subtotals ? Can you explain a little and give us an example screenshot of your output.

pavansonu99 · ‎2017-03-13

Hi Devarasu,

There is no much information in this post.

nagarjuna_kotha · ‎2017-03-13

Incomplete question,

Please explain briefly with sample data and expected result.

It helps you get answer quickly.

-Nagarjun

pavansonu99 · ‎2017-03-13

i am not asking any scenario.

i just want to know how page break works in pivot or straight table

nagarjuna_kotha · ‎2017-03-13

I'M exited know what is page break up.

Can u explain ,what do you mean by page break up?

-Nagarjun

devarasu07 · ‎2017-03-13

Hi Nagaraj,

He was looking Page break (report header to be repeated each page like that because if we take printout we lost the report column header ). Tks,

Conditional Breaks

Inserts a page break, unless all rows with the following dimension value can be fitted on the current page.

Forced Breaks

Inserts a page break whenever the dimension value changes

chart (straight / pivot table )properties --> u can enable conditional break method.

and also you can achieve by doing Nprint - excel report

by default pdf output will give right expected result.

Thanks

Deva

pavansonu99 · ‎2017-03-13

devarasu07 · ‎2017-03-13

Hi Pavan,

how page break works in pivot or straight table?

This setting only applies page breaks in the printout from a pivot table or straight table.

Three modes are available, with the following effects:

No Breaks:

It will only insert page breaks at the end of each page, as required.

Conditional Breaks

It inserts a page break, unless all rows with the following dimension value can be fitted on the current page.

Forced Breaks:

inserts a page break whenever the dimension value changes.

for more refer Chart Properties: Dimensions

Hope this helps.

Thanks,

Deva