Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Data is like string type as $0.6M or $0.9-- how to get only values

Data is like string type as  $0.6M or $0.9-- how to get only values such as 0.6 or 0.9 
I tried in tmap StringHandling.EREPLACE(StringHandling.EREPLACE(row2.Matrix,"$",""),"M","") 
But i am getting it as 
$0.60 
$ is still there. Please suggest.
Thanks,
Rahul
Labels (2)
3 Replies
Anonymous
Not applicable
Author

getting output as $0.6 still dollar sign is there .
In previous post copy paste error
Anonymous
Not applicable
Author

try this expression:
( row2.Matrix.replace("$", "")).replace("M", "") 
Anonymous
Not applicable
Author

Hi Shong,
Many thanks for fast and accurate response. The solution worked . 0683p000009MACn.png
Rahul