topic Re: adding a string in expression in QlikView https://community.qlik.com/t5/QlikView/adding-a-string-in-expression/m-p/557916#M208271 <HTML><HEAD></HEAD><BODY><P>Although saying that, I just tested it and the 'M' doesn't show on the axis.</P></BODY></HTML> Thu, 12 Dec 2013 10:09:59 GMT Anonymous 2013-12-12T10:09:59Z adding a string in expression https://community.qlik.com/t5/QlikView/adding-a-string-in-expression/m-p/557910#M208265 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P><IMG alt="eg1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/50281_eg1.png" /></P><P> here am showing the total sales as 100,000,000.</P><P></P><P>I need this to show as 100M that is in millions, like</P><P><IMG alt="eg2.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/50306_eg2.jpg" /></P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 11 Dec 2013 09:46:30 GMT https://community.qlik.com/t5/QlikView/adding-a-string-in-expression/m-p/557910#M208265 2013-12-11T09:46:30Z Re: adding a string in expression https://community.qlik.com/t5/QlikView/adding-a-string-in-expression/m-p/557911#M208266 <HTML><HEAD></HEAD><BODY><P>Hi Remya</P><P></P><P> in tab "Numbers", you can check box Millions</P><P></P><P>best regards</P><P>chris</P></BODY></HTML> Wed, 11 Dec 2013 09:49:20 GMT https://community.qlik.com/t5/QlikView/adding-a-string-in-expression/m-p/557911#M208266 2013-12-11T09:49:20Z Re: adding a string in expression https://community.qlik.com/t5/QlikView/adding-a-string-in-expression/m-p/557912#M208267 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>&nbsp;&nbsp; I did that already but its not showing like "100M"&nbsp; as in the second chart i mentioned.</P></BODY></HTML> Wed, 11 Dec 2013 09:52:09 GMT https://community.qlik.com/t5/QlikView/adding-a-string-in-expression/m-p/557912#M208267 2013-12-11T09:52:09Z Re: adding a string in expression https://community.qlik.com/t5/QlikView/adding-a-string-in-expression/m-p/557913#M208268 <HTML><HEAD></HEAD><BODY><P>Hi Remya,</P><P></P><P>Just right click on your chart -&gt; Properties -&gt; Number</P><P><IMG alt="Untitled.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/50310_Untitled.png" style="width: 620px; height: 549px;" /></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Wed, 11 Dec 2013 09:52:46 GMT https://community.qlik.com/t5/QlikView/adding-a-string-in-expression/m-p/557913#M208268 Sokkorn 2013-12-11T09:52:46Z Re: adding a string in expression https://community.qlik.com/t5/QlikView/adding-a-string-in-expression/m-p/557914#M208269 <HTML><HEAD></HEAD><BODY><P>I did that, it will be like this<IMG alt="eg3.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/50308_eg3.png" /></P></BODY></HTML> Wed, 11 Dec 2013 09:57:23 GMT https://community.qlik.com/t5/QlikView/adding-a-string-in-expression/m-p/557914#M208269 2013-12-11T09:57:23Z Re: adding a string in expression https://community.qlik.com/t5/QlikView/adding-a-string-in-expression/m-p/557915#M208270 <HTML><HEAD></HEAD><BODY><P>A very quick and dirty solution is to divide your expression by 1,000,000 and then put an 'M' on the end of the number format pattern in Chart Properties -&gt; Number</P><P></P><P>Cheers,</P><P></P><P>Adam</P></BODY></HTML> Thu, 12 Dec 2013 10:06:30 GMT https://community.qlik.com/t5/QlikView/adding-a-string-in-expression/m-p/557915#M208270 Anonymous 2013-12-12T10:06:30Z Re: adding a string in expression https://community.qlik.com/t5/QlikView/adding-a-string-in-expression/m-p/557916#M208271 <HTML><HEAD></HEAD><BODY><P>Although saying that, I just tested it and the 'M' doesn't show on the axis.</P></BODY></HTML> Thu, 12 Dec 2013 10:09:59 GMT https://community.qlik.com/t5/QlikView/adding-a-string-in-expression/m-p/557916#M208271 Anonymous 2013-12-12T10:09:59Z