Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pthomas3253
New 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
Contributor III

Re: Qlik Sense Script load editor - Set number format

variable

SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15Smiley Tongue;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12Smiley Tongue;-15:f;-18:a;-21:z;-24:y';

since June'18? maybe april'18 already?

1 Reply
mikaelsc
Contributor III

Re: Qlik Sense Script load editor - Set number format

variable

SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15Smiley Tongue;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12Smiley Tongue;-15:f;-18:a;-21:z;-24:y';

since June'18? maybe april'18 already?