Qlik Community

Qlik Sense App Development

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

claudemir_dioto
New 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 ?

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