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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
claudemir_dioto
Contributor III
Contributor III

Fixed decimal point in the American standard

Hy

After making the load of a .QVD file in a field with decimal separator is equal to ',' to try to include this field in Qlik Sense he is considering the decimal separator in the American standard , that is, equal to '.'. The environment variables are registered for the Portuguese standard , as follows:

SET ThousandSep = ' . ' ;

SET DecimalSep = ' ' ;

SET MoneyThousandSep = ' . ' ;

SET MoneyDecimalSep = ' ' ;

How will I use this field as a Geo location to generate a point on the map ( GeoMakePoint ) , the QlikSense does not interpret correctly.

Can anyone help me ?

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Use the num() function to give it the correct numeric format: num(MyField,'0,0',',','.') as MyField


talk is cheap, supply exceeds demand