topic Re: num format in QlikView https://community.qlik.com/t5/QlikView/num-format/m-p/980515#M334734 <HTML><HEAD></HEAD><BODY><P>Are you saying that *100 is giving you the same number as /100? or is the formatting is still the same?</P></BODY></HTML> Wed, 09 Dec 2015 12:18:17 GMT sunny_talwar 2015-12-09T12:18:17Z num format https://community.qlik.com/t5/QlikView/num-format/m-p/980511#M334730 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>i hve exp&nbsp;&nbsp; in text object</P><P></P><P> ExP; num((count(Def_ID)),'#.#00'))*100</P><P>my result is 107994.44444444</P><P></P><P>Expexted output:&nbsp; 10.79%</P><P></P><P>how can i achieve in text object?</P><P></P><P>thanks in advance''</P><P></P><P>Suresh</P></BODY></HTML> Wed, 09 Dec 2015 12:12:07 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980511#M334730 Chanty4u 2015-12-09T12:12:07Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980512#M334731 <HTML><HEAD></HEAD><BODY><P>May be you need to divide by 100 instead of multiply by 100</P><P></P><P><STRONG>Num((Count(Def_ID)/100, '##.00%')</STRONG></P></BODY></HTML> Wed, 09 Dec 2015 12:13:49 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980512#M334731 sunny_talwar 2015-12-09T12:13:49Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980513#M334732 <HTML><HEAD></HEAD><BODY><P>Try <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">num((count(Def_ID)),'#.#00'))/100</SPAN></P></BODY></HTML> Wed, 09 Dec 2015 12:14:15 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980513#M334732 roger_stone 2015-12-09T12:14:15Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980514#M334733 <HTML><HEAD></HEAD><BODY><P>no sunny...its also givng same</P></BODY></HTML> Wed, 09 Dec 2015 12:16:45 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980514#M334733 Chanty4u 2015-12-09T12:16:45Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980515#M334734 <HTML><HEAD></HEAD><BODY><P>Are you saying that *100 is giving you the same number as /100? or is the formatting is still the same?</P></BODY></HTML> Wed, 09 Dec 2015 12:18:17 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980515#M334734 sunny_talwar 2015-12-09T12:18:17Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980516#M334735 <HTML><HEAD></HEAD><BODY><P>No luck.....roger</P></BODY></HTML> Wed, 09 Dec 2015 12:18:47 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980516#M334735 Chanty4u 2015-12-09T12:18:47Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980517#M334736 <HTML><HEAD></HEAD><BODY><P>Try this as well</P><P></P><P><EM>​=num((count(Def_ID)),'#.#00')*100&amp;'%'</EM></P></BODY></HTML> Wed, 09 Dec 2015 12:19:48 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980517#M334736 its_anandrjs 2015-12-09T12:19:48Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980518#M334737 <HTML><HEAD></HEAD><BODY><P>the actual formulae....the above mentioned exp is denomenator&nbsp; that shud be *100</P></BODY></HTML> Wed, 09 Dec 2015 12:20:29 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980518#M334737 Chanty4u 2015-12-09T12:20:29Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980519#M334738 <HTML><HEAD></HEAD><BODY><P>This seems to be working:</P><P></P><P>=Num((1079.9444444444/10000), '##.00%')</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/108447_Capture.PNG" style="height: auto;" /></P><P></P><P>So may be try dividing by 10000 instead of 100</P><P></P><P><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>Num((Count(Def_ID)/10000, '##.00%')</STRONG></SPAN></P></BODY></HTML> Wed, 09 Dec 2015 12:21:39 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980519#M334738 sunny_talwar 2015-12-09T12:21:39Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980520#M334739 <HTML><HEAD></HEAD><BODY><P>share your complete formula buddy..then only we can help you..</P></BODY></HTML> Wed, 09 Dec 2015 12:22:28 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980520#M334739 Anonymous 2015-12-09T12:22:28Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980521#M334740 <HTML><HEAD></HEAD><BODY><P>no anand....it shwng as % wit same result</P></BODY></HTML> Wed, 09 Dec 2015 12:27:29 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980521#M334740 Chanty4u 2015-12-09T12:27:29Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980522#M334741 <HTML><HEAD></HEAD><BODY><P>what about this??</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">Num((Count(Def_ID)/10000, '##.00%') shared by Sunny</STRONG></P></BODY></HTML> Wed, 09 Dec 2015 12:31:14 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980522#M334741 Anonymous 2015-12-09T12:31:14Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980523#M334742 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=num((count(Def_ID)),'#.00%')</SPAN></P></BODY></HTML> Wed, 09 Dec 2015 12:31:48 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980523#M334742 Kushal_Chawda 2015-12-09T12:31:48Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980524#M334743 <HTML><HEAD></HEAD><BODY><P>am using&nbsp; in text object</P><P></P><P>=(count(Def_ID) -sum(if(Def_Status='Duplicate' or Def_Status='Withdrawn' or Def_Status='Rejected',1,0))</P><P>&nbsp; / </P><P>&nbsp; num((count(Def_ID)),'#.#000')*100&amp;'%')</P></BODY></HTML> Wed, 09 Dec 2015 12:31:58 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980524#M334743 Chanty4u 2015-12-09T12:31:58Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980525#M334744 <HTML><HEAD></HEAD><BODY><P>that is wrkng but... i need the formuale *100&nbsp; not .'/'</P></BODY></HTML> Wed, 09 Dec 2015 12:32:36 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980525#M334744 Chanty4u 2015-12-09T12:32:36Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980526#M334745 <HTML><HEAD></HEAD><BODY><P>Okay, you need *100 <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>then this?</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Num((Count(Def_ID)/1000000, '##.00%')*100</STRONG></P></BODY></HTML> Wed, 09 Dec 2015 12:36:37 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980526#M334745 Anonymous 2015-12-09T12:36:37Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980527#M334746 <HTML><HEAD></HEAD><BODY><P>Share your sample file with expected output.</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Wed, 09 Dec 2015 12:41:16 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980527#M334746 its_anandrjs 2015-12-09T12:41:16Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980528#M334747 <HTML><HEAD></HEAD><BODY><P>that missing closing bracet ...its wrkng fine</P></BODY></HTML> Wed, 09 Dec 2015 12:48:24 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980528#M334747 Chanty4u 2015-12-09T12:48:24Z Re: num format https://community.qlik.com/t5/QlikView/num-format/m-p/980529#M334748 <HTML><HEAD></HEAD><BODY><P>Try with<STRONG> floor(),</STRONG> like:</P><P></P><P>Floor(count(Def_ID),<STRONG> 0.01</STRONG>) &amp;'%'</P></BODY></HTML> Wed, 09 Dec 2015 12:48:46 GMT https://community.qlik.com/t5/QlikView/num-format/m-p/980529#M334748 tresB 2015-12-09T12:48:46Z