topic Re: Number Format in NPrinting in Qlik NPrinting

Number Format in NPrinting

madmax88 — Tue, 20 Nov 2018 16:26:31 GMT

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?

Re: Number Format in NPrinting

Ruggero_Piccoli — Wed, 21 Nov 2018 10:36:58 GMT

Hi,

Check the regional settings of the Qlik NPrinting Server and Engines.

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

Re: Number Format in NPrinting

madmax88 — Wed, 21 Nov 2018 11:05:49 GMT

I already changed regional Settings of the Server (but after the Installation of NPrinting).

Where are the Regional Settings of Enignes?

I have the User Settings and there the regional Settings are correct..

Re: Number Format in NPrinting

Ruggero_Piccoli — Wed, 21 Nov 2018 11:07:34 GMT

Yes, also in all the Engines.

Re: Number Format in NPrinting

madmax88 — Wed, 21 Nov 2018 11:56:56 GMT

@Ruggero_Piccoli wrote:
Yes, also in all the Engines.

And where are These Settings?

Re: Number Format in NPrinting

Ruggero_Piccoli — Wed, 21 Nov 2018 12:01:32 GMT

Hi,

I mean Windows Regional Settings. There it is specified the character that will be used as decimal separator etc. Be sure that in all the computers where Qlik NPrinting Server and Engines are installed they are set to the value you want.

Re: Number Format in NPrinting

madmax88 — Wed, 21 Nov 2018 12:09:11 GMT

Ok,

The regional Settings of the qlik sense NPrinting Server and of the Qlik Sense Server are fine. (decimal = . and tousand separator ='). It still doesnt work.

Important:

In the Designer itself it Shows me the correct decimal. Only when I send the Report by pdf or preview it's changing back to "," as decimal.

Is it not a "TFormatSetting" Problem?

Re: Number Format in NPrinting

Ruggero_Piccoli — Wed, 21 Nov 2018 13:47:39 GMT

Hi,

Based on some tests you need to check the Windows regional settings of all Qlik NPrinting Server and Engines computer by login with the Windows user that runs the Qlik NPrinting Windows services.
If you change the regional setting you must restart the Qlik NPrinting Windows services that are running on that computer. The reason is that the services read the settings only during the startup.

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

Re: Number Format in NPrinting

madmax88 — Wed, 21 Nov 2018 14:59:12 GMT

Thanks for your help! It's working now. The Problem was that the Regional Setting on the Server was only on my User. So I had also to Change it on the Service User and on The Service User on the Qlik Sense Server. Then I re-installed NPrinting.

Now It Works! I'm not sure if all steps above were necessary but at least I'm fine now.

Re: Number Format in NPrinting

vlad_komarov — Fri, 11 Dec 2020 03:29:59 GMT

Hi!

We are facing a similar problem, but in our case we need to make this format change dynamic. We need to send reports based on EU and US formats to different clients. We can do these distributions one after another, but we need to have an option to switch the settings without reinstalling the NP system.

Do you know if it's possible?

Re: Number Format in NPrinting

Ruggero_Piccoli — Fri, 11 Dec 2020 12:01:54 GMT

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