Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Highlighted
psankepalli
Contributor III

NPrinting Export Pivot Table to Powerpoint

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

2 Replies
devarasu07
Honored Contributor II

Re: NPrinting Export Pivot Table to Powerpoint

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
Contributor III

Re: NPrinting Export Pivot Table to Powerpoint

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

Community Browser