Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
pthomas3253
Contributor II
Contributor II

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
Creator III
Creator III

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
Creator III
Creator III

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