topic Money Formating in QlikView https://community.qlik.com/t5/QlikView/Money-Formating/m-p/1319879#M516081 <HTML><HEAD></HEAD><BODY><P>I have Money Value '2.33G'. But I want to convert it into 'M' so what is Expression for it.</P></BODY></HTML> Fri, 14 Apr 2017 08:47:36 GMT dhavalvyas 2017-04-14T08:47:36Z Money Formating https://community.qlik.com/t5/QlikView/Money-Formating/m-p/1319879#M516081 <HTML><HEAD></HEAD><BODY><P>I have Money Value '2.33G'. But I want to convert it into 'M' so what is Expression for it.</P></BODY></HTML> Fri, 14 Apr 2017 08:47:36 GMT https://community.qlik.com/t5/QlikView/Money-Formating/m-p/1319879#M516081 dhavalvyas 2017-04-14T08:47:36Z Re: Money Formating https://community.qlik.com/t5/QlikView/Money-Formating/m-p/1319880#M516082 <HTML><HEAD></HEAD><BODY><P>What is G here?</P></BODY></HTML> Fri, 14 Apr 2017 08:52:59 GMT https://community.qlik.com/t5/QlikView/Money-Formating/m-p/1319880#M516082 MK_QSL 2017-04-14T08:52:59Z Re: Money Formating https://community.qlik.com/t5/QlikView/Money-Formating/m-p/1319881#M516083 <HTML><HEAD></HEAD><BODY><P>I suppose it's billion like "giga"</P></BODY></HTML> Fri, 14 Apr 2017 10:19:38 GMT https://community.qlik.com/t5/QlikView/Money-Formating/m-p/1319881#M516083 Anonymous 2017-04-14T10:19:38Z Re: Money Formating https://community.qlik.com/t5/QlikView/Money-Formating/m-p/1319882#M516084 <HTML><HEAD></HEAD><BODY><P>Just divide by 1000 ?</P></BODY></HTML> Fri, 14 Apr 2017 11:12:48 GMT https://community.qlik.com/t5/QlikView/Money-Formating/m-p/1319882#M516084 Anonymous 2017-04-14T11:12:48Z Re: Money Formating https://community.qlik.com/t5/QlikView/Money-Formating/m-p/1319883#M516085 <HTML><HEAD></HEAD><BODY><P>multiply ! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 14 Apr 2017 11:13:39 GMT https://community.qlik.com/t5/QlikView/Money-Formating/m-p/1319883#M516085 Anonymous 2017-04-14T11:13:39Z Re: Money Formating https://community.qlik.com/t5/QlikView/Money-Formating/m-p/1319884#M516086 <HTML><HEAD></HEAD><BODY><P>That might work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Fri, 14 Apr 2017 11:17:08 GMT https://community.qlik.com/t5/QlikView/Money-Formating/m-p/1319884#M516086 Anonymous 2017-04-14T11:17:08Z Re: Money Formating https://community.qlik.com/t5/QlikView/Money-Formating/m-p/1319885#M516087 <HTML><HEAD></HEAD><BODY><P>Actually you should import that xxxG value as a regular (altho large) number into QlikView, and use the Number formatting fields to display it in a different format. That way you can still perform arithmetic or aggregation on its actual value.</P></BODY></HTML> Fri, 14 Apr 2017 14:11:45 GMT https://community.qlik.com/t5/QlikView/Money-Formating/m-p/1319885#M516087 Peter_Cammaert 2017-04-14T14:11:45Z