Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

New Contributor III

Fixed decimal point in the American standard


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 ?

Tags (2)
1 Reply

Re: Fixed decimal point in the American standard

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

talk is cheap, supply exceeds demand