Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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