topic Text box showing £ amount in QlikView https://community.qlik.com/t5/QlikView/Text-box-showing-amount/m-p/111051#M762797 <HTML><HEAD></HEAD><BODY><P>Hello all, </P><P></P><P>I am trying to show text box in £, however I can;t seem to figure it out.</P><P></P><P>Any help would be great.</P><P></P><P>Expression I am using is </P><P></P><P>=sum(([Refund amount:],'£#,###'))</P><P></P><P>Many thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT mohiahmed 2020-11-25T16:16:04Z Text box showing £ amount https://community.qlik.com/t5/QlikView/Text-box-showing-amount/m-p/111051#M762797 <HTML><HEAD></HEAD><BODY><P>Hello all, </P><P></P><P>I am trying to show text box in £, however I can;t seem to figure it out.</P><P></P><P>Any help would be great.</P><P></P><P>Expression I am using is </P><P></P><P>=sum(([Refund amount:],'£#,###'))</P><P></P><P>Many thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Text-box-showing-amount/m-p/111051#M762797 mohiahmed 2020-11-25T16:16:04Z Re: Text box showing £ amount https://community.qlik.com/t5/QlikView/Text-box-showing-amount/m-p/111052#M762798 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Money</STRONG>(Sum(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">[Refund amount:]</SPAN>),<STRONG>'£#,###')</STRONG></SPAN></P></BODY></HTML> Tue, 07 Aug 2018 07:07:41 GMT https://community.qlik.com/t5/QlikView/Text-box-showing-amount/m-p/111052#M762798 tresB 2018-08-07T07:07:41Z Re: Text box showing £ amount https://community.qlik.com/t5/QlikView/Text-box-showing-amount/m-p/111053#M762799 <HTML><HEAD></HEAD><BODY><P>Brilliant, many thanks and works perfectly.</P></BODY></HTML> Tue, 07 Aug 2018 07:55:58 GMT https://community.qlik.com/t5/QlikView/Text-box-showing-amount/m-p/111053#M762799 mohiahmed 2018-08-07T07:55:58Z