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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 (1)
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