Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Creator III
Creator III

Re: Qlik Sense Script load editor - Set number format

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

Re: Qlik Sense Script load editor - Set number format

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