Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
aiman_arshad
Contributor
Contributor

Nprinting - Pivot table format issue

Hi,

I'm trying to insert a pivot table in an excel report.

But i couldn't manage to have the same format as the one in Qlikview.

It's a  pivot table where i put the dimensions in columns and the expressions in rows. 

I need to have the Labels centered for both dimensions and expressions. It's centered in Qliview but Nprinting outputs labels on left.

Could you help me with this issue ? Note that "Keep Source Format" in properties is already checked.

Thank you

Labels (2)
2 Replies
Frank_S
Support
Support

Hi @aiman_arshad 

Can you provide two sample images as follows:

  • Expected results
  • Actual results

This would help in order to provide you with a possible solution path.

Thank you.

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Daniel_Jenkins
Specialist III
Specialist III

Hi @aiman_arshad ,

Note that when a Qlik pivot table is used as-is, NPrinting attempts to keep source formatting on a "best effort" basis. There can be some differences - for example dimensions will be repeated and center/right header alignment will not be retained (as you found). For complete control over your formatting you should consider recreating the pivot table in Excel.

See this discussion for more information:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Nprinting-Pivot-table-issue/td-p/128791

HTH - Daniel.