topic Nprinting - Pivot table format issue in Qlik NPrinting

Nprinting - Pivot table format issue

aiman_arshad — Sat, 16 Nov 2024 03:14:33 GMT

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

Re: Nprinting - Pivot table format issue

Frank_S — Wed, 19 Jun 2019 15:42:18 GMT

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.

Re: Nprinting - Pivot table format issue

Daniel_Jenkins — Thu, 20 Jun 2019 00:54:16 GMT

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.