https://community.qlik.com/t5/Suggest-an-Idea/Auto-format-mode-with-the-thousand-separator/idi-p/1814814 <P>Hi,</P><P>Banks have the auto format for all values , but want the exact value when it's under a million (with thousand separator).<BR />The KPI chart doesn't display correctly the value.&nbsp;</P><P>Keep in mind that there is more than a hundred measures in each apps.</P><P>In the main script, the variables are on the ThousandSep &amp; the&nbsp;NumericalAbbreviation.</P><P>SET ThousandSep="'";<BR />SET DecimalSep='.';<BR />SET MoneyThousandSep="'";<BR />SET MoneyDecimalSep='.';<BR />SET MoneyFormat='#&nbsp;##0.00 CHF;-#&nbsp;##0.00 CHF';<BR />SET TimeFormat='hh:mm:ss';<BR />SET DateFormat='DD.MM.YYYY';<BR />SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';<BR />SET FirstWeekDay=0;<BR />SET BrokenWeeks=0;<BR />SET ReferenceDay=4;<BR />SET FirstMonthOfYear=1;<BR />SET CollationLocale='fr-CH';<BR />SET CreateSearchIndexOnReload=1;<BR />SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';<BR />SET LongMonthNames='janvier;février;mars;avril;mai;juin;juillet;août;septembre;octobre;novembre;décembre';<BR />SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';<BR />SET LongDayNames='lundi;mardi;mercredi;jeudi;vendredi;samedi;dimanche';<BR />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';<BR />//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';</P><P>&nbsp;</P><P>When the number format is set to Number. The value is display with the thousand separator</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="t_donnet_0-1623660668176.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/56752i6C5D35897C61BDCD/image-size/medium?v=v2&amp;px=400" role="button" title="t_donnet_0-1623660668176.png" alt="t_donnet_0-1623660668176.png" /></span></P><P>&nbsp;</P><P>No problem here</P><P>&nbsp;</P><P>When the number format is set to Auto. The value is displays with the abbreviation (more than 1 million)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="t_donnet_1-1623660668371.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/56751i8AF2476AE278219C/image-size/medium?v=v2&amp;px=400" role="button" title="t_donnet_1-1623660668371.png" alt="t_donnet_1-1623660668371.png" /></span></P><P>&nbsp;</P><P>This is correct</P><P>&nbsp;</P><P>When the number format is set to Auto. The value is displays with the abbreviation (less than 1 million, no abbreviation)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="t_donnet_2-1623660668372.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/56749iF128C95A27FA75B7/image-size/medium?v=v2&amp;px=400" role="button" title="t_donnet_2-1623660668372.png" alt="t_donnet_2-1623660668372.png" /></span></P><P>&nbsp;</P><P>No thousand separator</P><P><BR />Thanks for your help.</P><P>Regards,<BR />Théo</P> Mon, 14 Jun 2021 08:54:31 GMT t_donnet 2021-06-14T08:54:31Z https://community.qlik.com/t5/Suggest-an-Idea/Auto-format-mode-with-the-thousand-separator/idc-p/1857672#M7766 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="francesco_menin_0-1636551592586.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66356i5FE8A482A58E0BD4/image-size/medium?v=v2&amp;px=400" role="button" title="francesco_menin_0-1636551592586.png" alt="francesco_menin_0-1636551592586.png" /></span></P> <P>totally need this feature when changing default numerical abbreviations</P> Wed, 10 Nov 2021 13:40:57 GMT https://community.qlik.com/t5/Suggest-an-Idea/Auto-format-mode-with-the-thousand-separator/idc-p/1857672#M7766 francesco_menin 2021-11-10T13:40:57Z https://community.qlik.com/t5/Suggest-an-Idea/Auto-format-mode-with-the-thousand-separator/idc-p/1882016#M8470 <P>Thank you all for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea by commenting and liking.</P><P>Thanks,&nbsp;<BR />Patric</P> Mon, 17 Jan 2022 18:37:45 GMT https://community.qlik.com/t5/Suggest-an-Idea/Auto-format-mode-with-the-thousand-separator/idc-p/1882016#M8470 Patric_Nordstrom 2022-01-17T18:37:45Z https://community.qlik.com/t5/Suggest-an-Idea/Auto-format-mode-with-the-thousand-separator/idc-p/2099920#M13195 <P>From now on, please track this idea from the Ideation portal.&nbsp;</P><P><STRONG><A title="Link to new idea" href="https://ideation.qlik.com/app/#/case/273640" target="_blank" rel="noopener">Link to new idea</A></STRONG></P><P>Meghann</P><P data-unlink="true"><EM>NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you <STRONG>only</STRONG> see 1 tab with the login page, please try clicking this link first: <STRONG><A title="Authenticate me!" href="#" target="_blank" rel="noopener">Authenticate me!</A></STRONG>&nbsp;t</EM><EM>hen try the link above again. Ensure pop-up blocker is off.</EM></P> Wed, 02 Aug 2023 15:05:47 GMT https://community.qlik.com/t5/Suggest-an-Idea/Auto-format-mode-with-the-thousand-separator/idc-p/2099920#M13195 Meghann_MacDonald 2023-08-02T15:05:47Z https://community.qlik.com/t5/Suggest-an-Idea/Auto-format-mode-with-the-thousand-separator/idc-p/2099921#M13196 Wed, 02 Aug 2023 15:05:48 GMT https://community.qlik.com/t5/Suggest-an-Idea/Auto-format-mode-with-the-thousand-separator/idc-p/2099921#M13196 Ideation 2023-08-02T15:05:48Z