Pivot as an image NP

[ilanbaruch]

Hi all

in my report i embed a large pivot table ,

1. in the message received there is a scroll is there a setting to fully expand this object to eliminate the scroll ?

2. in the end of the object there is empty area without any data a of the pivot,  is there a way to eliminate the surplus ?

advanced thanks

[Ruggero_Piccoli]

Hi,

Please always specify the version of the softwares you are using, if you are connecting to Qlik Sense or QlikView and the type of report you are editing.

If you are working on an Excel template the best solution is to re-create the pivot table as explained in https://help.qlik.com/en-US/nprinting/November2018/Content/NPrinting/ExcelReports/Pivot-table-Excel..... In this case you will be sure that all data will be included.

If you want to export the object as image you need to edit the source document in order to remove the scroll bars.

Best Regards,

Ruggero