topic Cast as number in QlikView https://community.qlik.com/t5/QlikView/Cast-as-number/m-p/374747#M139557 <HTML><HEAD></HEAD><BODY><P>Hi guys </P><P>Im stuck with a pretty simple issue.</P><P>I have to load from excel table a factor like this 0,0016.</P><P>When I load in QV it interprets that value as 0.</P><P>Im trying to use the num and num# but can't hit.</P><P>Someone know what is the correct format?</P><P></P><P>Thanks</P></BODY></HTML> Fri, 29 Jun 2012 14:26:10 GMT 2012-06-29T14:26:10Z Cast as number https://community.qlik.com/t5/QlikView/Cast-as-number/m-p/374747#M139557 <HTML><HEAD></HEAD><BODY><P>Hi guys </P><P>Im stuck with a pretty simple issue.</P><P>I have to load from excel table a factor like this 0,0016.</P><P>When I load in QV it interprets that value as 0.</P><P>Im trying to use the num and num# but can't hit.</P><P>Someone know what is the correct format?</P><P></P><P>Thanks</P></BODY></HTML> Fri, 29 Jun 2012 14:26:10 GMT https://community.qlik.com/t5/QlikView/Cast-as-number/m-p/374747#M139557 2012-06-29T14:26:10Z Re: Cast as number https://community.qlik.com/t5/QlikView/Cast-as-number/m-p/374748#M139558 <HTML><HEAD></HEAD><BODY><P>In order to clasify.</P><P>I need to use it as 0.0016</P></BODY></HTML> Fri, 29 Jun 2012 14:27:29 GMT https://community.qlik.com/t5/QlikView/Cast-as-number/m-p/374748#M139558 2012-06-29T14:27:29Z Re: Cast as number https://community.qlik.com/t5/QlikView/Cast-as-number/m-p/374749#M139559 <HTML><HEAD></HEAD><BODY><P>can you post the exaple?So i can help you</P></BODY></HTML> Fri, 29 Jun 2012 14:41:32 GMT https://community.qlik.com/t5/QlikView/Cast-as-number/m-p/374749#M139559 2012-06-29T14:41:32Z Re: Cast as number https://community.qlik.com/t5/QlikView/Cast-as-number/m-p/374750#M139560 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Use this in your load script for the table containing factor:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Num(Num#(factor, '0,0000', '',', ' '), '0.0000', '.', ' ') as factor</P><P></P><P>Hope that helps</P><P>Jonathan</P></BODY></HTML> Fri, 29 Jun 2012 14:49:17 GMT https://community.qlik.com/t5/QlikView/Cast-as-number/m-p/374750#M139560 jonathandienst 2012-06-29T14:49:17Z