NPrinting Export Pivot Table to Powerpoint

[psankepalli]

Hello All,

I am trying to export pivot table to power point through NPrinting on Qlikview.

Requirement is :

1. one metric contains $ value and another metric contains % values.

I want to export Pivot table with $ value and % values with transperant background.

When I checked source format, I am getting $, % signs on pivot table at each column, but can't make back ground color transparent. If I unchecked Source format I can make Pivot table as transparent but missing $ and % signs. How to get that?

2. How to make header and dimensions columns bold on power point pivot table?

Environment:

NPrinting 2017 September

QlikView 11.2.0

appriciate your help in advance.

Thanks

SP

[devarasu07]

Hi,

Try to Keep Source Formats property is active by default in your excel template (i.e it will show same your qlikview format)

or if you unchecked that option then u have to use custom formate like below (update your field instead of Amount)

money format :

num(Amount,'$#,##0.00')

of

num(Amount,'$#,##0')

% in your measure

num(Amount,'#,##0.0%')

for more check

http://help.qlik.com/en-US/nprinting/September2017/Content/ReportsDevelopment/WhichFormatsCanIUseCol...

Thanks

Deva

[psankepalli]

Hi Devarasu,

Thank you for your response, By the way, I am exporting to Powerpoint and not to the Excel. I want to export transparent Pivot table to Powerpoint. If you keep the Source format as checked, I am getting pivot table with white background. Which is not a requirement. and changing the data format is not working as you mentioned.

Please advise.

Thanks

SP