Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Thanvi
Contributor
Contributor

How to remove $ sign from colum values?

I have a column "Amount" with values as show below, how can I display only the rows in the table which has a value of more than 25000 in this column. 

Amount

$15000

$26000

$29000

$12000

$14000

I can use the limitation option only on numerical values, i.e if I can remove the $ sign from the above values. Or, is there an easier way to do this?

Labels (6)
1 Reply
JuanGerardo
Partner - Specialist
Partner - Specialist

Hi @Thanvi, you can use Money# function to convert your money amounts to numbers, and then manipulate them in an easier way.

JG