Hi,
Banks have the auto format for all values , but want the exact value when it's under a million (with thousand separator).
The KPI chart doesn't display correctly the value.
Keep in mind that there is more than a hundred measures in each apps.
In the main script, the variables are on the ThousandSep & the NumericalAbbreviation.
SET ThousandSep="'";
SET DecimalSep='.';
SET MoneyThousandSep="'";
SET MoneyDecimalSep='.';
SET MoneyFormat='# ##0.00 CHF;-# ##0.00 CHF';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';
SET FirstWeekDay=0;
SET BrokenWeeks=0;
SET ReferenceDay=4;
SET FirstMonthOfYear=1;
SET CollationLocale='fr-CH';
SET CreateSearchIndexOnReload=1;
SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';
SET LongMonthNames='janvier;février;mars;avril;mai;juin;juillet;août;septembre;octobre;novembre;décembre';
SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';
SET LongDayNames='lundi;mardi;mercredi;jeudi;vendredi;samedi;dimanche';
SET NumericalAbbreviation='6:mio;9:mia;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';
//SET NumericalAbbreviation='3:k;6:M;9:bn;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';
When the number format is set to Number. The value is display with the thousand separator
![t_donnet_0-1623660668176.png t_donnet_0-1623660668176.png](https://community.qlik.com/t5/image/serverpage/image-id/56752i6C5D35897C61BDCD/image-size/medium?v=v2&px=400)
No problem here
When the number format is set to Auto. The value is displays with the abbreviation (more than 1 million)
![t_donnet_1-1623660668371.png t_donnet_1-1623660668371.png](https://community.qlik.com/t5/image/serverpage/image-id/56751i8AF2476AE278219C/image-size/medium?v=v2&px=400)
This is correct
When the number format is set to Auto. The value is displays with the abbreviation (less than 1 million, no abbreviation)
![t_donnet_2-1623660668372.png t_donnet_2-1623660668372.png](https://community.qlik.com/t5/image/serverpage/image-id/56749iF128C95A27FA75B7/image-size/medium?v=v2&px=400)
No thousand separator
Thanks for your help.
Regards,
Théo