Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Nprinting designer column width issue

Hi,

I'm having trouble with nprinting designer in the excel template. (Nprinting version 19.9.5.0, MS Office 2016).

I have a pivot table but I can't center labels and set the right column width.

This pivot table comes from a straight table in qlik sense.

I've tried with no success:

 - Unchecking "Keep source formats" ;

 - deleting the table, reload the metadata, reopen nprinting designer and build the pivot table again;

 - setting in the page layout the width to 1 page (the table fits in one page but is very tiny);

 - adjusting the column width manually.

What else can I do to resolve this issue? 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Employee
Employee

Hi,

This is an Excel native feature. In the Qlik NPrinting Excel template:

  1. Select a cell in the Pivot Table.
  2. Display the Analyze tab of the ribbon.
  3. Click the PivotTable tool at the left side of the ribbon. Excel displays some options.
  4. Click Options. ...
  5. Make sure the Layout & Format tab is displayed.
  6. Make sure the Autofit Column Widths on Update check box is cleared.
  7. Click OK.
  8. Run a report preview.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

2 Replies
Highlighted
Employee
Employee

Hi,

This is an Excel native feature. In the Qlik NPrinting Excel template:

  1. Select a cell in the Pivot Table.
  2. Display the Analyze tab of the ribbon.
  3. Click the PivotTable tool at the left side of the ribbon. Excel displays some options.
  4. Click Options. ...
  5. Make sure the Layout & Format tab is displayed.
  6. Make sure the Autofit Column Widths on Update check box is cleared.
  7. Click OK.
  8. Run a report preview.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

Highlighted
Partner
Partner

Thanks, that did it!