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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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