Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I believe it doesn't need any explanation.
Hi,
Its not a bug as you can see qlik consider 0.009123 as 9.12m because in first section of script editor it is by default specifies that to consider NumericalAbbreviation for -3 numbers as m.
please check this row of variable in 1st section of script editor.
SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';
You can also change in any other letter.
Or if you want the exact same number to be displayed use Num() function.
Regards,
Prashant
Hi,
Its not a bug as you can see qlik consider 0.009123 as 9.12m because in first section of script editor it is by default specifies that to consider NumericalAbbreviation for -3 numbers as m.
please check this row of variable in 1st section of script editor.
SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';
You can also change in any other letter.
Or if you want the exact same number to be displayed use Num() function.
Regards,
Prashant