Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
MarcoRaymundoKeyrus
Partner - Contributor III
Partner - Contributor III

NPrinting April 2019 - PowerPoint report - Format Values native table

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

Labels (2)
3 Replies
Frank_S
Support
Support

Hi @MarcoRaymundoKeyrus 

Please check the solution here:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/NPRINTING-number-precision-in-Power-Point-T...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Frank_S
Support
Support

@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-T...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
MarcoRaymundoKeyrus
Partner - Contributor III
Partner - Contributor III
Author

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?