Fixed decimal point in the American standard

claudemir_dioto — Fri, 09 Jan 2015 12:36:52 GMT

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 ?

Re: Fixed decimal point in the American standard

Gysbert_Wassenaar — Fri, 09 Jan 2015 16:13:00 GMT

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

topic Fixed decimal point in the American standard in App Development

Fixed decimal point in the American standard

Re: Fixed decimal point in the American standard