I want to remove three strings from a table in qlikview. LIKE LPA,lpa AND INR

Question

1.2lpa    
2 LPA      
INR 20000.      

These are the records available and i need only numerical by triming the rest . What function and logic could be applied?

Replace(CurrentCTC, 'LPA' , '' ).

But the above function removes only LPA

Answer 1

You can use KeepChar function in your case. The function accept chars which should be kept after it

KeepChar(CurrentCTC, '0123456789')

You can read more about this function in Qlik's help page about KeepChar