Remove all separators but the last one

[AIShatiLove]

Hi

I have a problem.  In file i have a  number-column  where comma and dots are separators. And they are mixed up

i have :  1,205.34  ;  15,05 ;  12.64 ;  504,63 ... etc.

How i can Remove all except the last separator in qlik load ,  to get numbers as : 1205.34; 15.05; 12.64; 504.63  etc 

[PrashantSangle]

When I load your data in my qv, then it is working fine for me. even I don't write any logic.

[AIShatiLove]

Are all values read as numbers  without any replacment ? Cause if i replace in excel "," with "" the sum will be different
Maybe problem is that i load directly from excel file ? 

[AIShatiLove]

and why, if i do the same replace in qlik load  replace(fieldname, ',', '') the sum will be different after the same operation in excel 

[AIShatiLove]

please look, I didn't change anything from the source file and just uploaded it in a qlick. Here's what the manager shows me .  These are different types of data, right ?