topic Sum Problem in QlikView https://community.qlik.com/t5/QlikView/Sum-Problem/m-p/168203#M39463 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>If i understand your requirement correctly, you can append <B>Num</B> method in load script while loading the data from excel file. Please refer QlikView Help document for formatting the number.</P><P>Hope this will help you.</P><P>Regards,</P></BODY></HTML> Thu, 04 Mar 2010 10:45:53 GMT gajapathy74 2010-03-04T10:45:53Z Sum Problem https://community.qlik.com/t5/QlikView/Sum-Problem/m-p/168202#M39462 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>I have an Ecel file which have some numeric value in text format . When I edit the cell and press enter it turns to numeric. When I reload this excel file without fixinig text formated to numeric values I couldn't make Sum. Is it possible to get sum without changing the cell format from the excel file.</P><P>I also have some field with percentage symbol. I also want to sum them. Please also help me about this. Are there any specific statement like trim.</P><P>Hope to hear you soon.</P><P>Best Regards,</P><P></P></BODY></HTML> Thu, 04 Mar 2010 09:47:53 GMT https://community.qlik.com/t5/QlikView/Sum-Problem/m-p/168202#M39462 2010-03-04T09:47:53Z Sum Problem https://community.qlik.com/t5/QlikView/Sum-Problem/m-p/168203#M39463 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>If i understand your requirement correctly, you can append <B>Num</B> method in load script while loading the data from excel file. Please refer QlikView Help document for formatting the number.</P><P>Hope this will help you.</P><P>Regards,</P></BODY></HTML> Thu, 04 Mar 2010 10:45:53 GMT https://community.qlik.com/t5/QlikView/Sum-Problem/m-p/168203#M39463 gajapathy74 2010-03-04T10:45:53Z