topic Formatting a number as thousands in App Development https://community.qlik.com/t5/App-Development/Formatting-a-number-as-thousands/m-p/658794#M10049 <HTML><HEAD></HEAD><BODY><P>Really simple one here!</P><P></P><P>How do I write an expresion that formats numbers as £10k (for example).</P><P></P><P>I know I need to concatenate the 'k' on the end, but can't seem to find the right script to do this.</P><P></P><P>Cheers</P><P></P><P>Tom</P></BODY></HTML> Sat, 04 Oct 2014 14:51:25 GMT 2014-10-04T14:51:25Z Formatting a number as thousands https://community.qlik.com/t5/App-Development/Formatting-a-number-as-thousands/m-p/658794#M10049 <HTML><HEAD></HEAD><BODY><P>Really simple one here!</P><P></P><P>How do I write an expresion that formats numbers as £10k (for example).</P><P></P><P>I know I need to concatenate the 'k' on the end, but can't seem to find the right script to do this.</P><P></P><P>Cheers</P><P></P><P>Tom</P></BODY></HTML> Sat, 04 Oct 2014 14:51:25 GMT https://community.qlik.com/t5/App-Development/Formatting-a-number-as-thousands/m-p/658794#M10049 2014-10-04T14:51:25Z Re: Formatting a number as thousands https://community.qlik.com/t5/App-Development/Formatting-a-number-as-thousands/m-p/658795#M10050 <HTML><HEAD></HEAD><BODY><P>You can use that:</P><P></P><P><STRONG>=Num([your_field]/1000,'#,##0.00 k')</STRONG></P><P></P><P>your field divided by 1000 and whit the format </P></BODY></HTML> Sat, 04 Oct 2014 15:37:51 GMT https://community.qlik.com/t5/App-Development/Formatting-a-number-as-thousands/m-p/658795#M10050 ecolomer 2014-10-04T15:37:51Z