topic Re: calculate function sum it doesn't work in QlikView https://community.qlik.com/t5/QlikView/calculate-function-sum-it-doesn-t-work/m-p/432021#M566816 <HTML><HEAD></HEAD><BODY><P>Gijsbert</P><P></P><P>weer bedankt!!!</P><P></P><P>mvg</P><P></P><P>anton</P></BODY></HTML> Wed, 12 Dec 2012 19:43:35 GMT 2012-12-12T19:43:35Z calculate function sum it doesn't work https://community.qlik.com/t5/QlikView/calculate-function-sum-it-doesn-t-work/m-p/432019#M566814 <HTML><HEAD></HEAD><BODY><P>hello</P><P></P><P>maby a stupid question</P><P></P><P>i am importing xml files in qlikview, then i will calculate the sum of all tickets.</P><P></P><P>but he don't do this </P><P></P><P>please help me </P><P></P><P>see attachment</P></BODY></HTML> Wed, 12 Dec 2012 19:33:49 GMT https://community.qlik.com/t5/QlikView/calculate-function-sum-it-doesn-t-work/m-p/432019#M566814 2012-12-12T19:33:49Z Re: calculate function sum it doesn't work https://community.qlik.com/t5/QlikView/calculate-function-sum-it-doesn-t-work/m-p/432020#M566815 <HTML><HEAD></HEAD><BODY><P>Your ThousandSep variable is set to a dot . </P><P></P><P>SET ThousandSep='.';</P><P>SET DecimalSep=',';</P><P></P><P> That causes your amounts to be treated as strings, since they're not valid numbers. If you change the dots and comma's it should work.</P></BODY></HTML> Wed, 12 Dec 2012 19:40:10 GMT https://community.qlik.com/t5/QlikView/calculate-function-sum-it-doesn-t-work/m-p/432020#M566815 Gysbert_Wassenaar 2012-12-12T19:40:10Z Re: calculate function sum it doesn't work https://community.qlik.com/t5/QlikView/calculate-function-sum-it-doesn-t-work/m-p/432021#M566816 <HTML><HEAD></HEAD><BODY><P>Gijsbert</P><P></P><P>weer bedankt!!!</P><P></P><P>mvg</P><P></P><P>anton</P></BODY></HTML> Wed, 12 Dec 2012 19:43:35 GMT https://community.qlik.com/t5/QlikView/calculate-function-sum-it-doesn-t-work/m-p/432021#M566816 2012-12-12T19:43:35Z