topic Re: Displaying an expression calculation as £, %, etc in QlikView https://community.qlik.com/t5/QlikView/Displaying-an-expression-calculation-as-etc/m-p/520318#M1121532 <HTML><HEAD></HEAD><BODY><P>See the text boxes in the attached.</P></BODY></HTML> Thu, 16 Jan 2014 16:43:47 GMT Nicole-Smith 2014-01-16T16:43:47Z Displaying an expression calculation as £, %, etc https://community.qlik.com/t5/QlikView/Displaying-an-expression-calculation-as-etc/m-p/520317#M1121531 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I'm having trouble getting some of my expressions to display properly.&nbsp; I've created a series of expressions in Text Objects to show on the front page of a dashboard.</P><P></P><P>The formulas I'm struggling with are:</P><P></P><P>=Num(Sum([Let Date]-[Void Date]-1)) / (count(Address))</P><P></P><P>I need this one as '##.##'</P><P></P><P>=Count([Termination Reason])/14606</P><P></P><P>I need this one as '##.##%'</P><P></P><P>=Num(Avg(Current_Balance),Count ([Welfare_Reform_Alert]= 'Yes'), '£#,###.##')</P><P></P><P>This one says "expression OK", but doesn't actually display!</P><P></P><P>I also have a couple more where it won't display a comma, using:</P><P>, '###,###')</P><P></P><P>Can anyone point me in the right direction?</P><P></P><P>TYIA.</P><P><BR />Regards</P><P><BR />Alex</P></BODY></HTML> Thu, 16 Jan 2014 10:45:22 GMT https://community.qlik.com/t5/QlikView/Displaying-an-expression-calculation-as-etc/m-p/520317#M1121531 2014-01-16T10:45:22Z Re: Displaying an expression calculation as £, %, etc https://community.qlik.com/t5/QlikView/Displaying-an-expression-calculation-as-etc/m-p/520318#M1121532 <HTML><HEAD></HEAD><BODY><P>See the text boxes in the attached.</P></BODY></HTML> Thu, 16 Jan 2014 16:43:47 GMT https://community.qlik.com/t5/QlikView/Displaying-an-expression-calculation-as-etc/m-p/520318#M1121532 Nicole-Smith 2014-01-16T16:43:47Z