Dynamically changing Decimals and Thousands Separator for NPrining PDF reports

[vlad_komarov]

Hi All,

I've searched the forum and was surpised to learn that nobody have experienced the problem we need to address:

We do have reports distributed to different clients around the globe (EU/US/Asia). These regions are using different numeric and money formats, different thousands and decimal separators (like 8,999.99 US or 8.999,00 EU).

There are few recomendations posted about doing this switch permanently, but in our case we need to make this format change dynamic. We need to send reports based on EU and US formats on the same day, usually. We can do these distributions one after another, but we need to have an option to switch the settings without reinstalling the whole NP system (as most of the solutions suggesting)

Do you know if it's possible?

Appreciate your input.

Regards,

Vladimir

[pradosh_thakur]

In the expresion may be something similar to below. Use keep source format show it picks the format as per the region.

If not Europe below expression will pick the general format else the other

pick(match(Region,'Europe')+1,num(sum(sales),'##,###.##','.',','),num(sum(sales),'##.###,##',',','.'))

[vlad_komarov]

It has nothing to do with expressions in QS. The problem is with Excel, as far as I understand:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/NP19-Excel-report-always-shows-decimal-numb...

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/NPrinting-17-5-Sep-2017-Wrong-decimal-thous...