How to handle currency column in qlik sense?

[Vikash938]

Salary
$125.50
$63.46
$43.27
$29.85
$32.69
$32.69
$50.48

How to handle this type of column where i want to separate $ sign from it and only numeric value i need it.?

[MatheusC · Accepted solution]

@Vikash938 
If the format comes from your source data, you can make the adjustment directly in the table containing the field using the script, using the replace() function:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunc...

Replace([Salary], '$', '') as NewField

To process the field as a number, see using Num()

https://help.qlik.com/pt-BR/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunc...

Num() or Num#(Replace(Salary, '$', ''),'[optional format]').

If this isn't possible in the script, it can also be done in the preview.

- Regards, Matheus

[Lech_Miszkiewicz]

duplicated post - elegant solution provided by @Or in that post. 

https://community.qlik.com/t5/Move-to-Qlik-Cloud-Analytics/How-to-handle-currency-column-in-Qlik-sen...

cheers

[Vikash938]

Thank you... it really helpful.