topic Re: Conversion in QlikView https://community.qlik.com/t5/QlikView/Conversion/m-p/775526#M274972 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Divide the numbers by million in expression</P><P></P><P>=Num(Sum(SomeMeasure)/1000000, '#,###.0')</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Wed, 19 Nov 2014 08:08:55 GMT jagan 2014-11-19T08:08:55Z Conversion https://community.qlik.com/t5/QlikView/Conversion/m-p/775524#M274970 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have data something like 185012499.98, I want to convert into 185.0 in qlikview. Its a pivot chart and Million and thousands are disabled. </P><P>Please help me with this.</P><P>I want the above data in this format 185.0. Its in Million </P><P></P><P>Thanks,</P><P>Keerthi KS</P></BODY></HTML> Wed, 19 Nov 2014 07:56:12 GMT https://community.qlik.com/t5/QlikView/Conversion/m-p/775524#M274970 2014-11-19T07:56:12Z Re: Conversion https://community.qlik.com/t5/QlikView/Conversion/m-p/775525#M274971 <HTML><HEAD></HEAD><BODY><P>=Num(Value / 1000000,'#0.0M')</P></BODY></HTML> Wed, 19 Nov 2014 07:59:05 GMT https://community.qlik.com/t5/QlikView/Conversion/m-p/775525#M274971 MK_QSL 2014-11-19T07:59:05Z Re: Conversion https://community.qlik.com/t5/QlikView/Conversion/m-p/775526#M274972 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Divide the numbers by million in expression</P><P></P><P>=Num(Sum(SomeMeasure)/1000000, '#,###.0')</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Wed, 19 Nov 2014 08:08:55 GMT https://community.qlik.com/t5/QlikView/Conversion/m-p/775526#M274972 jagan 2014-11-19T08:08:55Z