topic Round off to two decimals problem in QlikView https://community.qlik.com/t5/QlikView/Round-off-to-two-decimals-problem/m-p/364848#M1174704 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>For me it working fine (QV11 SR1).</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Wed, 23 May 2012 08:43:24 GMT Sokkorn 2012-05-23T08:43:24Z Round off to two decimals problem https://community.qlik.com/t5/QlikView/Round-off-to-two-decimals-problem/m-p/364845#M1174701 <HTML><HEAD></HEAD><BODY><P>Hey!</P><P></P><P>Let's say i have:</P><P></P><P>=sum([Antal arbetade timmar]/Timmar)</P><P></P><P>And the answer in the gauge chart is showing 0.49345565767672</P><P></P><P>When i press properties and choose number, and the choose "fixed to" and click the "show as %" it does not work? That means that nothing happends.</P><P></P><P>I have also tried the num function but i can't get that to word either, and how to i get it to show the % in the num funtion?</P><P></P><P>I want the gauge chart to show 49.3%</P><P></P><P>Thankfull for helping answer!</P></BODY></HTML> Wed, 23 May 2012 08:24:31 GMT https://community.qlik.com/t5/QlikView/Round-off-to-two-decimals-problem/m-p/364845#M1174701 2012-05-23T08:24:31Z Round off to two decimals problem https://community.qlik.com/t5/QlikView/Round-off-to-two-decimals-problem/m-p/364846#M1174702 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Let try =NUM(sum([Antal arbetade timmar]/Timmar),'00.0%')</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Wed, 23 May 2012 08:34:20 GMT https://community.qlik.com/t5/QlikView/Round-off-to-two-decimals-problem/m-p/364846#M1174702 Sokkorn 2012-05-23T08:34:20Z Round off to two decimals problem https://community.qlik.com/t5/QlikView/Round-off-to-two-decimals-problem/m-p/364847#M1174703 <HTML><HEAD></HEAD><BODY><P>Yeah nice, thats the solution.</P><P></P><P>Do you know why the properties -&gt; number -&gt; "fixed to" does not work?</P><P></P><P>Thanks for the help!</P></BODY></HTML> Wed, 23 May 2012 08:39:26 GMT https://community.qlik.com/t5/QlikView/Round-off-to-two-decimals-problem/m-p/364847#M1174703 2012-05-23T08:39:26Z Round off to two decimals problem https://community.qlik.com/t5/QlikView/Round-off-to-two-decimals-problem/m-p/364848#M1174704 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>For me it working fine (QV11 SR1).</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Wed, 23 May 2012 08:43:24 GMT https://community.qlik.com/t5/QlikView/Round-off-to-two-decimals-problem/m-p/364848#M1174704 Sokkorn 2012-05-23T08:43:24Z Round off to two decimals problem https://community.qlik.com/t5/QlikView/Round-off-to-two-decimals-problem/m-p/364849#M1174705 <HTML><HEAD></HEAD><BODY><P>Can you upload your app?</P></BODY></HTML> Wed, 23 May 2012 08:43:45 GMT https://community.qlik.com/t5/QlikView/Round-off-to-two-decimals-problem/m-p/364849#M1174705 Sokkorn 2012-05-23T08:43:45Z Round off to two decimals problem https://community.qlik.com/t5/QlikView/Round-off-to-two-decimals-problem/m-p/364850#M1174706 <HTML><HEAD></HEAD><BODY><P>No not really since the data is real customer data! But thanks anyway, i guess it's just a wierd bug or something!</P></BODY></HTML> Wed, 23 May 2012 08:45:37 GMT https://community.qlik.com/t5/QlikView/Round-off-to-two-decimals-problem/m-p/364850#M1174706 2012-05-23T08:45:37Z Round off to two decimals problem https://community.qlik.com/t5/QlikView/Round-off-to-two-decimals-problem/m-p/364851#M1174707 <HTML><HEAD></HEAD><BODY><P>That fine. What QV version you use?</P></BODY></HTML> Wed, 23 May 2012 08:48:01 GMT https://community.qlik.com/t5/QlikView/Round-off-to-two-decimals-problem/m-p/364851#M1174707 Sokkorn 2012-05-23T08:48:01Z Round off to two decimals problem https://community.qlik.com/t5/QlikView/Round-off-to-two-decimals-problem/m-p/364852#M1174708 <HTML><HEAD></HEAD><BODY><P>QV11 SR1, it's a personal licence.</P></BODY></HTML> Wed, 23 May 2012 09:17:53 GMT https://community.qlik.com/t5/QlikView/Round-off-to-two-decimals-problem/m-p/364852#M1174708 2012-05-23T09:17:53Z