Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Use the num() function to give it the correct numeric format: num(MyField,'0,0',',','.') as MyField