Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlik Sense Script load editor - Set number format

I want to be able to SET the number format at the app level so that when Auto number is selected for a KPI it will show K, M, B (instead of G), or T. Numbers range from K - B so I don't want to use the Num fuction at the beginning of an expression.  Any help, greatly appreciated!

Thank you!

1 Solution

Accepted Solutions
mikaelsc
Specialist
Specialist

variable

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';

since June'18? maybe april'18 already?

View solution in original post

1 Reply
mikaelsc
Specialist
Specialist

variable

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';

since June'18? maybe april'18 already?