Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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';
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';