Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
AIShatiLove
Contributor III
Contributor III

Remove all separators but the last one

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 

Labels (1)
13 Replies
PrashantSangle

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
AIShatiLove
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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 ?

AIShatiLove_0-1614340927426.png