How to remove $symbol from Qlikview script?

[dolly777]

Hi All,

My data source is SQL , one column contains data with $symbol. While I am loading data from that column to my QVW I did not get any data from that column.. How to fix that issue.

Thanks in Advance.

[prma7799]

Please share some screenshot of that column with data...

[dolly777]

Hi

I am getting value in list box but while applying in function I did not get any value. So, to remove $ symbol in script level while loading I used autonumber that time  I am getting mismatching value or if I do not use autonumber that listbox value is correct but no result is showing in function

Thanks in  advance

[tresesco]

Use purgechar() , like :

Load

          Purgechar( [FieldName], '$') as Newfield

[prma7799]

Try this

PurgeChar(Yourfield,'$') as Newfield

or

KeepChar(Yourfield,1234567890) as Newfield

[dolly777]

Hi

Thank you very much it  is working fine:)

[tresesco]

It's good practice to mark replies correct/helpful in your posts. Qlik Community Tip: Marking Replies as Correct or Helpful

[Ankit1988]

Hi try and its work