Skip to main content
Announcements
Qlik Acquires Upsolver to Advance Iceberg Solutions: READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Paulo_IntelFab
Contributor III
Contributor III

DecimalSep and ThousandSep: it doesn`t show the right way on sheet

I need to show numeric values in the Brazilian format:  1.000,00 (decimal separator is a comma and thousand separator a final point). 

I've set this parameters on the load script. In the visualization area, it shows the correct format, as shown in the picture: 

Paulo_IntelFab_1-1728317779852.png

But, on the visualization (sheet) it remains using the standard DecimalSep (.) and ThousandSep (,). 
The date filter used on sheet respects the Brazilian date format that I've set on the load script (DD/mm/YYYY). 

Paulo_IntelFab_2-1728317960841.png

Is there anything I missed? I appreciate any help. 

Labels (1)
  • SaaS

1 Solution

Accepted Solutions
Or
MVP
MVP

Check the master measure's formatting, both in the sense that it may have expression-level formatting (using the num() function) or a default format that is not what you want. Also, check for any formatting at the object level. Something worth looking at - open the Selections screen, find your field, and see what the format is there without any expressions applied.

 

View solution in original post

2 Replies
Or
MVP
MVP

Check the master measure's formatting, both in the sense that it may have expression-level formatting (using the num() function) or a default format that is not what you want. Also, check for any formatting at the object level. Something worth looking at - open the Selections screen, find your field, and see what the format is there without any expressions applied.

 

Paulo_IntelFab
Contributor III
Contributor III
Author

Thanks for Helping, @Or . 
I searched the object and found the "customize" format option. Applying this to the objects, it takes the values defined on the load script by default. 

It`s configured object by object (even inside tables), but it works fine.