Nprinting - Pivot table format issue

[aiman_arshad]

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

[Frank_S]

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.

[Daniel_Jenkins]

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.