topic Format number in table in App Development https://community.qlik.com/t5/App-Development/Format-number-in-table/m-p/2434586#M96903 <P>hello everyone, this is rather an easy question but i am not being able to solve this.</P> <P>I have a table, where my values are being displayed as this "$58395" but i would like to have them as this "$58,3K". How can i do that?&nbsp;</P> <P>the format pattern right now looks like this:&nbsp;#.##0 €;-#.##0 € . I played around with it but i just dont get it.&nbsp;</P> <P>&nbsp;</P> <P>thanks</P> Fri, 15 Nov 2024 21:01:15 GMT Nemo1 2024-11-15T21:01:15Z Format number in table https://community.qlik.com/t5/App-Development/Format-number-in-table/m-p/2434586#M96903 <P>hello everyone, this is rather an easy question but i am not being able to solve this.</P> <P>I have a table, where my values are being displayed as this "$58395" but i would like to have them as this "$58,3K". How can i do that?&nbsp;</P> <P>the format pattern right now looks like this:&nbsp;#.##0 €;-#.##0 € . I played around with it but i just dont get it.&nbsp;</P> <P>&nbsp;</P> <P>thanks</P> Fri, 15 Nov 2024 21:01:15 GMT https://community.qlik.com/t5/App-Development/Format-number-in-table/m-p/2434586#M96903 Nemo1 2024-11-15T21:01:15Z Re: Format number in table https://community.qlik.com/t5/App-Development/Format-number-in-table/m-p/2434592#M96904 <P>use num()</P> <P><A href="https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunctions/Num.htm" target="_blank">https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunctions/Num.htm</A></P> <P><A href="https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunctions/Money.htm" target="_blank">https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunctions/Money.htm</A></P> <P>Regards,</P> <P>Prashant Sangle</P> Tue, 26 Mar 2024 08:31:52 GMT https://community.qlik.com/t5/App-Development/Format-number-in-table/m-p/2434592#M96904 PrashantSangle 2024-03-26T08:31:52Z Re: Format number in table https://community.qlik.com/t5/App-Development/Format-number-in-table/m-p/2434604#M96905 <P>Try</P> <P>=Money('$58395'/1000, '$#,##0.0K')</P> Tue, 26 Mar 2024 09:07:13 GMT https://community.qlik.com/t5/App-Development/Format-number-in-table/m-p/2434604#M96905 BrunPierre 2024-03-26T09:07:13Z