topic How to change the value 12.3456 to 12.34 using string function in QlikView https://community.qlik.com/t5/QlikView/How-to-change-the-value-12-3456-to-12-34-using-string-function/m-p/1409466#M801822 <HTML><HEAD></HEAD><BODY><P>How to change the value 12.3456 to 12.34 using string function</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT arjakumar 2020-11-25T16:16:04Z How to change the value 12.3456 to 12.34 using string function https://community.qlik.com/t5/QlikView/How-to-change-the-value-12-3456-to-12-34-using-string-function/m-p/1409466#M801822 <HTML><HEAD></HEAD><BODY><P>How to change the value 12.3456 to 12.34 using string function</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-change-the-value-12-3456-to-12-34-using-string-function/m-p/1409466#M801822 arjakumar 2020-11-25T16:16:04Z Re: How to change the value 12.3456 to 12.34 using string function https://community.qlik.com/t5/QlikView/How-to-change-the-value-12-3456-to-12-34-using-string-function/m-p/1409467#M801823 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>using string fxn? if so just use the left fxn =left(12.3456,5)</P><P>better way is the number fxn like below</P><P>=Num(12.3456,'##.00')</P><P></P><P>i.e update your field name instead of the hard coded value</P></BODY></HTML> Fri, 17 Nov 2017 04:56:23 GMT https://community.qlik.com/t5/QlikView/How-to-change-the-value-12-3456-to-12-34-using-string-function/m-p/1409467#M801823 devarasu07 2017-11-17T04:56:23Z Re: How to change the value 12.3456 to 12.34 using string function https://community.qlik.com/t5/QlikView/How-to-change-the-value-12-3456-to-12-34-using-string-function/m-p/1409468#M801824 <HTML><HEAD></HEAD><BODY><P>Num(Value,'##.00')</P></BODY></HTML> Fri, 17 Nov 2017 04:57:53 GMT https://community.qlik.com/t5/QlikView/How-to-change-the-value-12-3456-to-12-34-using-string-function/m-p/1409468#M801824 Anil_Babu_Samineni 2017-11-17T04:57:53Z Re: How to change the value 12.3456 to 12.34 using string function https://community.qlik.com/t5/QlikView/How-to-change-the-value-12-3456-to-12-34-using-string-function/m-p/1409469#M801825 <HTML><HEAD></HEAD><BODY><P>Do you want to round the number (ie to 12.35) or round it down (to 12.34)?</P><P></P><P>Round up:&nbsp; Ceil(12.3456, 0.01)</P><P>Round:&nbsp; Round(12.3456, 0.01)</P><P>Round down:&nbsp; Floor(12.3456, 0.01)</P></BODY></HTML> Fri, 17 Nov 2017 04:59:06 GMT https://community.qlik.com/t5/QlikView/How-to-change-the-value-12-3456-to-12-34-using-string-function/m-p/1409469#M801825 jonathandienst 2017-11-17T04:59:06Z Re: How to change the value 12.3456 to 12.34 using string function https://community.qlik.com/t5/QlikView/How-to-change-the-value-12-3456-to-12-34-using-string-function/m-p/1409470#M801826 <HTML><HEAD></HEAD><BODY><P>I also want to change 12.3456 to 12.35 when 3rd postion after decimal point is &gt;=5.</P></BODY></HTML> Fri, 17 Nov 2017 05:09:51 GMT https://community.qlik.com/t5/QlikView/How-to-change-the-value-12-3456-to-12-34-using-string-function/m-p/1409470#M801826 arjakumar 2017-11-17T05:09:51Z