topic Re: NPrinting Export Pivot Table to Powerpoint in Qlik NPrinting

NPrinting Export Pivot Table to Powerpoint

psankepalli — Thu, 26 Oct 2017 03:15:13 GMT

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

Re: NPrinting Export Pivot Table to Powerpoint

devarasu07 — Thu, 26 Oct 2017 03:37:12 GMT

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')

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

% in your measure

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

for more check

http://help.qlik.com/en-US/nprinting/September2017/Content/ReportsDevelopment/WhichFormatsCanIUseColumns/Which-Formats-Columns.htm

Thanks

Deva

Re: NPrinting Export Pivot Table to Powerpoint

psankepalli — Thu, 26 Oct 2017 12:50:18 GMT

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