topic round Numbers to special format in QlikView https://community.qlik.com/t5/QlikView/round-Numbers-to-special-format/m-p/432311#M558366 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I want to round results in my graph to a special format:</P><P></P><P>(sum(Erlöse) +10000 =&gt; 64.993,22</P><P></P><P>round(sum(Erlöse) +10000)&nbsp; =&gt; 64.993</P><P></P><P>result wanted: 65.000</P><P></P><P>How do I get this?</P><P></P><P>Thank you for helping!</P></BODY></HTML> Mon, 03 Jun 2013 08:54:02 GMT Anonymous 2013-06-03T08:54:02Z round Numbers to special format https://community.qlik.com/t5/QlikView/round-Numbers-to-special-format/m-p/432311#M558366 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I want to round results in my graph to a special format:</P><P></P><P>(sum(Erlöse) +10000 =&gt; 64.993,22</P><P></P><P>round(sum(Erlöse) +10000)&nbsp; =&gt; 64.993</P><P></P><P>result wanted: 65.000</P><P></P><P>How do I get this?</P><P></P><P>Thank you for helping!</P></BODY></HTML> Mon, 03 Jun 2013 08:54:02 GMT https://community.qlik.com/t5/QlikView/round-Numbers-to-special-format/m-p/432311#M558366 Anonymous 2013-06-03T08:54:02Z Re: round Numbers to special format https://community.qlik.com/t5/QlikView/round-Numbers-to-special-format/m-p/432312#M558367 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Try round(sum(Erlöse) +10000,100) or maybe<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"> round(sum(Erlöse) +10000,1000) if you want to round to thousands instead of hundreds.</SPAN></SPAN></P></BODY></HTML> Mon, 03 Jun 2013 08:55:35 GMT https://community.qlik.com/t5/QlikView/round-Numbers-to-special-format/m-p/432312#M558367 Gysbert_Wassenaar 2013-06-03T08:55:35Z