topic Re: Num#() in QlikView https://community.qlik.com/t5/QlikView/Num/m-p/402497#M149794 <HTML><HEAD></HEAD><BODY><P>Try this </P><P>LOAD num( EVALUATE(No),'#0') as Num_Data from abc.qvd;</P></BODY></HTML> Thu, 11 Oct 2012 07:19:26 GMT sivarajs 2012-10-11T07:19:26Z Num#() https://community.qlik.com/t5/QlikView/Num/m-p/402496#M149793 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I was trying to convert a value which is in text format to number using NUM#() but i am not getting the expected value.the value is in the below format </P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 337px;"><TBODY><TR><TD class="xl63" height="17" width="337">66.99072</TD></TR><TR><TD class="xl63" height="17">67.2913</TD></TR><TR><TD class="xl63" height="17">67.6825</TD></TR><TR><TD class="xl63" height="17">67.29164</TD></TR><TR><TD class="xl63" height="17">67.37867</TD></TR><TR><TD class="xl63" height="17">67.40173</TD></TR><TR><TD class="xl63" height="17">67.58928</TD></TR><TR><TD class="xl63" height="17">67.59046</TD></TR></TBODY></TABLE><P></P><P>Plz any one help on this.</P></BODY></HTML> Thu, 11 Oct 2012 06:46:23 GMT https://community.qlik.com/t5/QlikView/Num/m-p/402496#M149793 2012-10-11T06:46:23Z Re: Num#() https://community.qlik.com/t5/QlikView/Num/m-p/402497#M149794 <HTML><HEAD></HEAD><BODY><P>Try this </P><P>LOAD num( EVALUATE(No),'#0') as Num_Data from abc.qvd;</P></BODY></HTML> Thu, 11 Oct 2012 07:19:26 GMT https://community.qlik.com/t5/QlikView/Num/m-p/402497#M149794 sivarajs 2012-10-11T07:19:26Z