Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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
Highlighted
Contributor 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
Highlighted
Contributor 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