topic Decimals in text object in QlikView https://community.qlik.com/t5/QlikView/Decimals-in-text-object/m-p/1047320#M941079 <HTML><HEAD></HEAD><BODY><P>How to reduce decimal points in text object</P><P></P><P>The result am getting is 68.90876890%</P><P></P><P>I need to reduce to 2-decimal like 68.90%</P></BODY></HTML> Thu, 21 Jan 2016 15:09:37 GMT nareshthavidishetty 2016-01-21T15:09:37Z Decimals in text object https://community.qlik.com/t5/QlikView/Decimals-in-text-object/m-p/1047320#M941079 <HTML><HEAD></HEAD><BODY><P>How to reduce decimal points in text object</P><P></P><P>The result am getting is 68.90876890%</P><P></P><P>I need to reduce to 2-decimal like 68.90%</P></BODY></HTML> Thu, 21 Jan 2016 15:09:37 GMT https://community.qlik.com/t5/QlikView/Decimals-in-text-object/m-p/1047320#M941079 nareshthavidishetty 2016-01-21T15:09:37Z Re: Decimals in text object https://community.qlik.com/t5/QlikView/Decimals-in-text-object/m-p/1047321#M941080 <HTML><HEAD></HEAD><BODY><P>You can use Num()</P><P></P><P>Num(Your_Field, '##.##%')</P></BODY></HTML> Thu, 21 Jan 2016 15:14:44 GMT https://community.qlik.com/t5/QlikView/Decimals-in-text-object/m-p/1047321#M941080 sinanozdemir 2016-01-21T15:14:44Z Re: Decimals in text object https://community.qlik.com/t5/QlikView/Decimals-in-text-object/m-p/1047322#M941081 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Num(Expression, '##.00%')</STRONG></P><P></P><P>or this:</P><P></P><P><STRONG>=Left(Expression, 5) &amp; '%'</STRONG></P></BODY></HTML> Thu, 21 Jan 2016 15:16:02 GMT https://community.qlik.com/t5/QlikView/Decimals-in-text-object/m-p/1047322#M941081 sunny_talwar 2016-01-21T15:16:02Z Re: Decimals in text object https://community.qlik.com/t5/QlikView/Decimals-in-text-object/m-p/1047323#M941082 <HTML><HEAD></HEAD><BODY><P>Hola,</P><P></P><P>Tienes dos formas:</P><P>O bien en el cuadro que estés usando, en propiedades, vas a la pestaña de número y defines el formato del número o bien, en la fórmula escribes el formato. Por ejemplo:<STRONG> =Num(Sum(Ventas) / Sum(TOTAL Ventas), '#.#0,00 %')</STRONG></P><P>Saludos,</P><P>Enrique Colomer</P></BODY></HTML> Thu, 21 Jan 2016 15:20:10 GMT https://community.qlik.com/t5/QlikView/Decimals-in-text-object/m-p/1047323#M941082 ecolomer 2016-01-21T15:20:10Z