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