topic String to number in QlikView https://community.qlik.com/t5/QlikView/String-to-number/m-p/266849#M1204227 <HTML><HEAD></HEAD><BODY><P>hey guys,</P><P>i have a simple problem, but i haven't come to a conclusion yet.<BR />After having loaded an excel sheet, qlikview displays my numbers as strings.<BR />I have tried using any kind of num function in the script, but it doesn't work.<BR />I just need the numbers, without decimals.</P><P>Sorry, but I'm a total Qlikview newb <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>thanks a lot!</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-1980_sourceID:1980" /></P><P></P></BODY></HTML> Thu, 22 Jul 2010 09:35:08 GMT 2010-07-22T09:35:08Z String to number https://community.qlik.com/t5/QlikView/String-to-number/m-p/266849#M1204227 <HTML><HEAD></HEAD><BODY><P>hey guys,</P><P>i have a simple problem, but i haven't come to a conclusion yet.<BR />After having loaded an excel sheet, qlikview displays my numbers as strings.<BR />I have tried using any kind of num function in the script, but it doesn't work.<BR />I just need the numbers, without decimals.</P><P>Sorry, but I'm a total Qlikview newb <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>thanks a lot!</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-1980_sourceID:1980" /></P><P></P></BODY></HTML> Thu, 22 Jul 2010 09:35:08 GMT https://community.qlik.com/t5/QlikView/String-to-number/m-p/266849#M1204227 2010-07-22T09:35:08Z String to number https://community.qlik.com/t5/QlikView/String-to-number/m-p/266850#M1204228 <HTML><HEAD></HEAD><BODY><P>Go chart properties and then go number tab click on integer.</P><P>Regards</P><P>Ashish Srivastava</P></BODY></HTML> Thu, 22 Jul 2010 09:50:35 GMT https://community.qlik.com/t5/QlikView/String-to-number/m-p/266850#M1204228 2010-07-22T09:50:35Z String to number https://community.qlik.com/t5/QlikView/String-to-number/m-p/266851#M1204229 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You need not apply any function.</P><P>Go to chart properties-Number</P><P>Select you dimension and tick "Fixed to".</P><P>Make no. of decimals zero.</P><P>It will answer your queries.</P><P>Happy Thoughts</P></BODY></HTML> Thu, 22 Jul 2010 09:58:53 GMT https://community.qlik.com/t5/QlikView/String-to-number/m-p/266851#M1204229 2010-07-22T09:58:53Z