Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
parviz_asoodehfard
Contributor III
Contributor III

If your number is less than .01, it will show incorrectly in KPI Chart!

parviz_asoodehfard_0-1610565558852.png

I believe it doesn't need any explanation.

 

 

1 Solution

Accepted Solutions
Prashant_N
Contributor III
Contributor III

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

View solution in original post

1 Reply
Prashant_N
Contributor III
Contributor III

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