topic Re: Page Breaks in pivot table in QlikView

Page Breaks in pivot table

pavansonu99 — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

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

Re: Page Breaks in pivot table

devarasu07 — Sun, 12 Mar 2017 16:41:31 GMT

Hi Pavan,

Maybe this discussion can help you

Re: Horizontal bar chart with horizontal scroll bar (paging button)

Tks,Deva

Re: Page Breaks in pivot table

vishsaggi — Sun, 12 Mar 2017 17:11:43 GMT

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

Re: Page Breaks in pivot table

pavansonu99 — Mon, 13 Mar 2017 05:45:35 GMT

Hi Devarasu,

There is no much information in this post.

Re: Page Breaks in pivot table

nagarjuna_kotha — Mon, 13 Mar 2017 05:57:41 GMT

Incomplete question,

Please explain briefly with sample data and expected result.

It helps you get answer quickly.

-Nagarjun

Re: Page Breaks in pivot table

pavansonu99 — Mon, 13 Mar 2017 06:03:04 GMT

i am not asking any scenario.

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

Re: Page Breaks in pivot table

nagarjuna_kotha — Mon, 13 Mar 2017 06:14:56 GMT

I'M exited know what is page break up.

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

-Nagarjun

Re: Page Breaks in pivot table

devarasu07 — Mon, 13 Mar 2017 06:17:28 GMT

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

Re: Page Breaks in pivot table

pavansonu99 — Mon, 13 Mar 2017 06:21:19 GMT

Re: Page Breaks in pivot table

devarasu07 — Mon, 13 Mar 2017 07:01:04 GMT

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

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Straight_Table.htm

Hope this helps.

Thanks,

Deva