Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
vlad_komarov
Partner - Specialist III
Partner - Specialist III

Dynamically changing Decimals and Thousands Separator for NPrining PDF reports

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

Labels (2)
2 Replies
pradosh_thakur
Master II
Master II

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),'##.###,##',',','.'))

 

Learning never stops.
vlad_komarov
Partner - Specialist III
Partner - Specialist III
Author