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: 
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