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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
GuglielmoBLB
Partner - Contributor
Partner - Contributor

How to change the decimal separator in the format string editor of the Pixel Perfect Editor in Qlik Cloud.

Hello everyone, is possible to use , instead of . as the decimal separator in the Pixel Perfect Template Editor? I tried using the Format String Editor and setting the format like this: {0:#.#,00}, but I got this result: 76444123.564. Thanks in advance for the support.

Labels (2)
1 Reply
Rahul18
Contributor II
Contributor II

 

1 Open your PixelPerfect template

2 Click on the Report Explorer panel (left side).

3. Select the top node (report root)

4. In the Properties window, find the Formatting Culture or Culture property.

5.Change the culture to one that uses comma (,) as decimal separator, such as:

de-DE (German - Germany)

fr-FR (French - France)

it-IT (Italian - Italy)

6 Save and preview the report.


it will render like:76.444.123,56
instead of:76,444,123.56