topic Re: short number format in QlikView https://community.qlik.com/t5/QlikView/short-number-format/m-p/688424#M536817 <HTML><HEAD></HEAD><BODY><P><IMG alt="2014-10-24_1651.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/69656_2014-10-24_1651.png" /></P></BODY></HTML> Fri, 24 Oct 2014 15:51:57 GMT rustyfishbones 2014-10-24T15:51:57Z short number format https://community.qlik.com/t5/QlikView/short-number-format/m-p/688418#M536811 <HTML><HEAD></HEAD><BODY><P>I had chart city, sales.</P><P>in sales column values are,</P><P>100000,</P><P>2340000,</P><P>2345600</P><P>how to show these values in million in chart&nbsp; like</P><P>1M,</P><P>2.34M,</P><P>2.3456m, </P></BODY></HTML> Fri, 24 Oct 2014 07:40:46 GMT https://community.qlik.com/t5/QlikView/short-number-format/m-p/688418#M536811 2014-10-24T07:40:46Z Re: short number format https://community.qlik.com/t5/QlikView/short-number-format/m-p/688419#M536812 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>=sales/1000000 &amp; 'M'</P><P></P><P>Hope it works <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 24 Oct 2014 07:47:31 GMT https://community.qlik.com/t5/QlikView/short-number-format/m-p/688419#M536812 maternmi 2014-10-24T07:47:31Z Re: short number format https://community.qlik.com/t5/QlikView/short-number-format/m-p/688420#M536813 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you have the option to override the number format within the chart properties (see attached), this can be done for each expression. The other option you have is to use Num() in your expression and use the second parameter to set the format</P><P></P><P>hope that helps</P><P>Joe</P></BODY></HTML> Fri, 24 Oct 2014 07:50:02 GMT https://community.qlik.com/t5/QlikView/short-number-format/m-p/688420#M536813 2014-10-24T07:50:02Z Re: Re: short number format https://community.qlik.com/t5/QlikView/short-number-format/m-p/688421#M536814 <HTML><HEAD></HEAD><BODY><P>Hi joe,</P><P>i did'nt understand how to get that.</P><P>can u plz modify this attachment.</P><P>thanks</P></BODY></HTML> Fri, 24 Oct 2014 15:39:22 GMT https://community.qlik.com/t5/QlikView/short-number-format/m-p/688421#M536814 2014-10-24T15:39:22Z Re: Re: Re: short number format https://community.qlik.com/t5/QlikView/short-number-format/m-p/688422#M536815 <HTML><HEAD></HEAD><BODY><P>Like this :</P></BODY></HTML> Fri, 24 Oct 2014 15:49:04 GMT https://community.qlik.com/t5/QlikView/short-number-format/m-p/688422#M536815 Anonymous 2014-10-24T15:49:04Z Re: short number format https://community.qlik.com/t5/QlikView/short-number-format/m-p/688423#M536816 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please check this attached file for solution.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Fri, 24 Oct 2014 15:49:25 GMT https://community.qlik.com/t5/QlikView/short-number-format/m-p/688423#M536816 jagan 2014-10-24T15:49:25Z Re: short number format https://community.qlik.com/t5/QlikView/short-number-format/m-p/688424#M536817 <HTML><HEAD></HEAD><BODY><P><IMG alt="2014-10-24_1651.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/69656_2014-10-24_1651.png" /></P></BODY></HTML> Fri, 24 Oct 2014 15:51:57 GMT https://community.qlik.com/t5/QlikView/short-number-format/m-p/688424#M536817 rustyfishbones 2014-10-24T15:51:57Z