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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
madmax88
Creator II
Creator II

Number Format in NPrinting

Hi,

I have a number Format Problem in Qlik Sense NPrinting Pixel Perfect.

In Charts I Formated the Point Labels to V{#.000%}. In the designer mode it Shows me correct with Point (e.g. 2.05%). But when I preview the Report it Shows me again with comma(,). And after "Save and Close" it's also Switch again to comma(",").

-->instead of 2.05% it shows 2,05%. How can I set it correct?

Also in the tousend separator I don't find the " '  " as separator. I only habe space (1 365) oder comma (1,365) but I Need 1'365. Where is this Setting Option?

I checked the NPrinting guide therefor and there is written:

"Decimal point. The first '.' character in the format string determines the location of the decimal separator in the formatted value; any additional '.' characters are ignored. The actual character used as a decimal separator in the output string is determined by the DecimalSeparator global variable or its TFormatSettings equivalent."

And the same in tousand separator.

So the "TFormatSetting" must be changed because it's determined as global, or not?

And If yes, where can I Change the TFormatSetting?Any ideas?

10 Replies
Ruggero_Piccoli
Support
Support

Hi,

Based on what I know Qlik NPrinting uses the regional settings of the computers where the Server and the Engines are installed. When you add, for example, the formatting string for a number and you insert the "." (dot) as decimal separator it mens "use the decimal separator set in the regional setting of the machine". So to change the separator in the resulting reports you have to change the settings of Engines and the Server.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.