topic Re: Convert text to numeric value and keep all decimals? in QlikView https://community.qlik.com/t5/QlikView/Convert-text-to-numeric-value-and-keep-all-decimals/m-p/984253#M335872 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12px; font-family: Consolas, 'Courier New', Courier, mono, serif; color: #000000;">Num(NUM#([Text Result], </SPAN><SPAN class="string" style="font-size: 12px; font-family: Consolas, 'Courier New', Courier, mono, serif; color: blue;">'#'</SPAN><SPAN style="font-size: 12px; font-family: Consolas, 'Courier New', Courier, mono, serif; color: #000000;">),'#.000') AS [Result]</SPAN></P></BODY></HTML> Thu, 15 Oct 2015 11:46:54 GMT Gysbert_Wassenaar 2015-10-15T11:46:54Z Convert text to numeric value and keep all decimals? https://community.qlik.com/t5/QlikView/Convert-text-to-numeric-value-and-keep-all-decimals/m-p/984252#M335871 <HTML><HEAD></HEAD><BODY><P>Some of the data are numbers, stored in text fields. When converting using:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14449036908839155" jivemacro_uid="_14449036908839155" modifiedtitle="true"> <P>NUM#([Text Result], '#') AS [Result]</P> </PRE><P></P><P>... it can give the following results:</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/102052_Capture.PNG" style="height: auto;" /></P><P>I want the same precision for the numeric value as the original text value, however this is not always what the code delivers. Why is the last two zeroes removed from row 4, but kept in row 2? How do I achieve what I need, what conversions are necessary?</P></BODY></HTML> Thu, 15 Oct 2015 10:20:41 GMT https://community.qlik.com/t5/QlikView/Convert-text-to-numeric-value-and-keep-all-decimals/m-p/984252#M335871 Anonymous 2015-10-15T10:20:41Z Re: Convert text to numeric value and keep all decimals? https://community.qlik.com/t5/QlikView/Convert-text-to-numeric-value-and-keep-all-decimals/m-p/984253#M335872 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12px; font-family: Consolas, 'Courier New', Courier, mono, serif; color: #000000;">Num(NUM#([Text Result], </SPAN><SPAN class="string" style="font-size: 12px; font-family: Consolas, 'Courier New', Courier, mono, serif; color: blue;">'#'</SPAN><SPAN style="font-size: 12px; font-family: Consolas, 'Courier New', Courier, mono, serif; color: #000000;">),'#.000') AS [Result]</SPAN></P></BODY></HTML> Thu, 15 Oct 2015 11:46:54 GMT https://community.qlik.com/t5/QlikView/Convert-text-to-numeric-value-and-keep-all-decimals/m-p/984253#M335872 Gysbert_Wassenaar 2015-10-15T11:46:54Z Re: Convert text to numeric value and keep all decimals? https://community.qlik.com/t5/QlikView/Convert-text-to-numeric-value-and-keep-all-decimals/m-p/984254#M335873 <HTML><HEAD></HEAD><BODY><P>Still doesn't work:</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/102091_Capture.PNG" style="height: auto;" /></P><P>Zeroes are sometimes still cut off.</P></BODY></HTML> Thu, 15 Oct 2015 11:55:29 GMT https://community.qlik.com/t5/QlikView/Convert-text-to-numeric-value-and-keep-all-decimals/m-p/984254#M335873 Anonymous 2015-10-15T11:55:29Z Re: Convert text to numeric value and keep all decimals? https://community.qlik.com/t5/QlikView/Convert-text-to-numeric-value-and-keep-all-decimals/m-p/984255#M335874 <HTML><HEAD></HEAD><BODY><P>Works for me. See attached example</P></BODY></HTML> Thu, 15 Oct 2015 16:12:18 GMT https://community.qlik.com/t5/QlikView/Convert-text-to-numeric-value-and-keep-all-decimals/m-p/984255#M335874 Gysbert_Wassenaar 2015-10-15T16:12:18Z