topic Re: Change number format in Qlik Sense in App Development

Change number format in Qlik Sense

sroettger — Tue, 22 Mar 2022 14:01:49 GMT

Hi. How can I change the number format in Qlik Sense from k (thousand) to T (German thousand euros)? Can I do this with a SET command in the loading script? I want the number e.g. 45.8 K to be followed by a t, i.e. 45.8 t....

Thank you!!!
Best Regards

Re: Change number format in Qlik Sense

Or — Tue, 22 Mar 2022 14:04:51 GMT

You should be able to do this in script. Change the below to match the required format (this should be placed in your script by default, based on the server's regional settings, I believe):

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