topic Re: NPrinting April 2019 - PowerPoint report - Format Values native table in Qlik NPrinting

NPrinting April 2019 - PowerPoint report - Format Values native table

MarcoRaymundoKeyrus — Tue, 17 Mar 2020 20:40:38 GMT

Hi!

I need to format the values in a native powerpoint table to present the values in the format 1,000,000. I tried the steps below:
1) The values in qlikview (12) are without formatting mask.
2) I unchecked Keep Source Formats.
3) In the value column, in the Format option, I include the format: #. ###

The result was: 1,000,000

I tried the format of item 3 to: #, ## 0, the result was: 1,000,000.

Does anybody know how to solve this?

Tks

Re: NPrinting April 2019 - PowerPoint report - Format Values native table

Frank_S — Thu, 21 Nov 2019 20:15:29 GMT

Hi @MarcoRaymundoKeyrus

Please check the solution here:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/NPRINTING-number-precision-in-Power-Point-Tables/m-p/1642207/highlight/true#M26772

Re: NPrinting April 2019 - PowerPoint report - Format Values native table

Frank_S — Thu, 21 Nov 2019 20:17:58 GMT

@MarcoRaymundoKeyrus

The following link is part of the same discussion but includes test files you are free to try.

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/NPRINTING-number-precision-in-Power-Point-Tables/m-p/1642230/highlight/true#M26776

Re: NPrinting April 2019 - PowerPoint report - Format Values native table

MarcoRaymundoKeyrus — Fri, 22 Nov 2019 19:57:00 GMT

Thank you! However it did not work, the values are still displayed in the format 1,000,000.00. Even for values in%, the values are displayed with the dot as decimal separator and comma as thousands separator.

Even formatting the values to fixed.

Do you have any other ideas?