Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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