topic Re: Convert Exponential values in Numbers??? in QlikView https://community.qlik.com/t5/QlikView/Convert-Exponential-values-in-Numbers/m-p/400462#M149037 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use</P><P></P><P>LOAD num(TO_BALANCE,'##################'), </P><P>&nbsp;&nbsp;&nbsp;&nbsp; ACTUAL_RATE</P><P>FROM ...</P></BODY></HTML> Wed, 12 Sep 2012 12:29:12 GMT jvitantonio 2012-09-12T12:29:12Z Convert Exponential values in Numbers??? https://community.qlik.com/t5/QlikView/Convert-Exponential-values-in-Numbers/m-p/400461#M149036 <HTML><HEAD></HEAD><BODY><P>Please find the attached document, </P><P></P><P>In my application, you'll notice that in Column TO_BALANCE containing data like 1e+017, </P><P>but i need to present the data which is not in the exponential form</P><P>i:e:- 100000000000000000</P><P></P><P>Regards.</P><P></P><P>Zain</P></BODY></HTML> Wed, 12 Sep 2012 12:17:54 GMT https://community.qlik.com/t5/QlikView/Convert-Exponential-values-in-Numbers/m-p/400461#M149036 2012-09-12T12:17:54Z Re: Convert Exponential values in Numbers??? https://community.qlik.com/t5/QlikView/Convert-Exponential-values-in-Numbers/m-p/400462#M149037 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use</P><P></P><P>LOAD num(TO_BALANCE,'##################'), </P><P>&nbsp;&nbsp;&nbsp;&nbsp; ACTUAL_RATE</P><P>FROM ...</P></BODY></HTML> Wed, 12 Sep 2012 12:29:12 GMT https://community.qlik.com/t5/QlikView/Convert-Exponential-values-in-Numbers/m-p/400462#M149037 jvitantonio 2012-09-12T12:29:12Z Re: Convert Exponential values in Numbers??? https://community.qlik.com/t5/QlikView/Convert-Exponential-values-in-Numbers/m-p/400463#M149038 <HTML><HEAD></HEAD><BODY><P>i applied it but, still have the same problem</P></BODY></HTML> Wed, 12 Sep 2012 12:36:37 GMT https://community.qlik.com/t5/QlikView/Convert-Exponential-values-in-Numbers/m-p/400463#M149038 2012-09-12T12:36:37Z Re: Convert Exponential values in Numbers??? https://community.qlik.com/t5/QlikView/Convert-Exponential-values-in-Numbers/m-p/400464#M149039 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;">Try using this </SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 12pt;"><SPAN style="color: #0000ff;">num</SPAN>(<SPAN style="color: #0000ff;">num#</SPAN>(<SPAN style="color: #800000;">TO_BALANCE</SPAN>),'##################') <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">TO_BALANCE</SPAN></SPAN></P></BODY></HTML> Wed, 12 Sep 2012 12:44:43 GMT https://community.qlik.com/t5/QlikView/Convert-Exponential-values-in-Numbers/m-p/400464#M149039 sivarajs 2012-09-12T12:44:43Z