topic How do I display large numbers in millions? in QlikView https://community.qlik.com/t5/QlikView/How-do-I-display-large-numbers-in-millions/m-p/634351#M1087777 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">I have a table box where I would like one field to display numbers in millions, i.e. turn 3,400,000 into $3.4M. How do I do this?</P><P style="text-align: left;"></P><P style="text-align: left;">Thanks!</P></BODY></HTML> Fri, 30 May 2014 17:26:30 GMT 2014-05-30T17:26:30Z How do I display large numbers in millions? https://community.qlik.com/t5/QlikView/How-do-I-display-large-numbers-in-millions/m-p/634351#M1087777 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">I have a table box where I would like one field to display numbers in millions, i.e. turn 3,400,000 into $3.4M. How do I do this?</P><P style="text-align: left;"></P><P style="text-align: left;">Thanks!</P></BODY></HTML> Fri, 30 May 2014 17:26:30 GMT https://community.qlik.com/t5/QlikView/How-do-I-display-large-numbers-in-millions/m-p/634351#M1087777 2014-05-30T17:26:30Z Re: How do I display large numbers in millions? https://community.qlik.com/t5/QlikView/How-do-I-display-large-numbers-in-millions/m-p/634352#M1087778 <HTML><HEAD></HEAD><BODY><P>Maybe like shown here:</P><P><A href="https://community.qlik.com/thread/55039">dynamically changing scale in text box</A></P></BODY></HTML> Fri, 30 May 2014 17:37:19 GMT https://community.qlik.com/t5/QlikView/How-do-I-display-large-numbers-in-millions/m-p/634352#M1087778 swuehl 2014-05-30T17:37:19Z Re: How do I display large numbers in millions? https://community.qlik.com/t5/QlikView/How-do-I-display-large-numbers-in-millions/m-p/634353#M1087779 <HTML><HEAD></HEAD><BODY><P>Have you tried doing anything with the num() function?</P></BODY></HTML> Fri, 30 May 2014 17:40:41 GMT https://community.qlik.com/t5/QlikView/How-do-I-display-large-numbers-in-millions/m-p/634353#M1087779 2014-05-30T17:40:41Z Re: How do I display large numbers in millions? https://community.qlik.com/t5/QlikView/How-do-I-display-large-numbers-in-millions/m-p/634354#M1087780 <HTML><HEAD></HEAD><BODY><P>Divide your expression by 1,000,000. Then:</P><P></P><P>Chart Properties -&gt; Number -&gt; Make the million symbol M</P></BODY></HTML> Fri, 30 May 2014 17:41:21 GMT https://community.qlik.com/t5/QlikView/How-do-I-display-large-numbers-in-millions/m-p/634354#M1087780 2014-05-30T17:41:21Z