Assistance with Number Formatting in Pixel Perfect Report - Qlik Cloud

[davenyrfajutag00]

Good morning everyone,

I’ve created a report in Pixel Perfect and need the data to be formatted using a comma (,) as the decimal separator and a dot (.) as the thousand separator unlike the current situation I have: 

Currently, I'm experiencing issues with the formatting. I’ve tried modifying the Text Format String from:
{0:€ #,##0.00;-€ #,##0.00}
to:
{0:€ #.##0,00;-€ #.##0,00}
but it doesn't produce the desired result. I also changed the language culture to it-IT, but it still doesn’t seem to work correctly.

Could you please assist me in resolving this?

Thank you in advance!

[Frank_S]

Good day!

Please check the solution posted in this thread.

Re: Tabular reporting - date and number formatting - Qlik Community - 2516123
The same applies to pixel perfect.

Kind regards,

[davenyrfajutag00]

Good morning Frank, I've changed the language properties in my profile settings but it still does not work properly.

Let me know, thank you!

[Frank_S]

@Ruggero_Piccoli Please assist when you have a moment. Thank you!

[Ruggero_Piccoli]

Hi,

We are investigating on a workaround or a way to do. I will post as soon as we will found it.

Best Regards,

Ruggero

[Denise1997]

Hi,

I experienced the same issue. As a workaround I have already converted the created field to a text format instead of a numeric format in the data load editor.

I hope this provides a solution for you as well.