topic Incorrect Data Format while reading calculated fields from SharePoint list in QlikView https://community.qlik.com/t5/QlikView/Incorrect-Data-Format-while-reading-calculated-fields-from/m-p/357824#M703475 <HTML><HEAD></HEAD><BODY><P> This should work, I think:<BR />floor(subfield("Material#", '#',2)) as "Material#"</P></BODY></HTML> Fri, 18 May 2012 01:12:17 GMT Anonymous 2012-05-18T01:12:17Z Incorrect Data Format while reading calculated fields from SharePoint list https://community.qlik.com/t5/QlikView/Incorrect-Data-Format-while-reading-calculated-fields-from/m-p/357823#M703474 <HTML><HEAD></HEAD><BODY><P>The data format is incorrect when I read calculated fields from a SharePoint list into QlikView. For example, I am reading the Material# field into QlikView from SharePoint. The value in SharePoint is "101294675". The&nbsp; value shown in QlikView is&nbsp; "float;#101294675.000000".&nbsp; Is there a script change I can make to ensure the value is diplayed as 101294675</P></BODY></HTML> Thu, 17 May 2012 21:33:23 GMT https://community.qlik.com/t5/QlikView/Incorrect-Data-Format-while-reading-calculated-fields-from/m-p/357823#M703474 2012-05-17T21:33:23Z Incorrect Data Format while reading calculated fields from SharePoint list https://community.qlik.com/t5/QlikView/Incorrect-Data-Format-while-reading-calculated-fields-from/m-p/357824#M703475 <HTML><HEAD></HEAD><BODY><P> This should work, I think:<BR />floor(subfield("Material#", '#',2)) as "Material#"</P></BODY></HTML> Fri, 18 May 2012 01:12:17 GMT https://community.qlik.com/t5/QlikView/Incorrect-Data-Format-while-reading-calculated-fields-from/m-p/357824#M703475 Anonymous 2012-05-18T01:12:17Z Incorrect Data Format while reading calculated fields from SharePoint list https://community.qlik.com/t5/QlikView/Incorrect-Data-Format-while-reading-calculated-fields-from/m-p/357825#M703476 <HTML><HEAD></HEAD><BODY><P> Thank you Michael.</P></BODY></HTML> Tue, 29 May 2012 19:08:39 GMT https://community.qlik.com/t5/QlikView/Incorrect-Data-Format-while-reading-calculated-fields-from/m-p/357825#M703476 2012-05-29T19:08:39Z