How to handle currency column in Qlik sense.

[Anonymous]

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.?

[Or]

Use the Money#() function.

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

For example,

Money#(Salary, $#,##0)

[Aurelien_Martinez]

Hi,

You can use replace()

Load
Replace(Salary, '$', '') as Salary2,
Salary
Inline [
Salary
$125.50
$63.46
$43.27
$29.85
$32.69
$32.69
$50.48
];

Aurélien

[QFabian]

Hi!

or you can use purge() funciton too