topic Re: How to remove $symbol from Qlikview script? in QlikView

How to remove $symbol from Qlikview script?

dolly777 — Thu, 02 Nov 2017 05:55:54 GMT

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.

Re: How to remove $symbol from Qlikview script?

prma7799 — Thu, 02 Nov 2017 05:57:46 GMT

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

Re: How to remove $symbol from Qlikview script?

dolly777 — Thu, 02 Nov 2017 06:09:08 GMT

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

Re: How to remove $symbol from Qlikview script?

tresB — Thu, 02 Nov 2017 06:15:57 GMT

Use purgechar() , like :

Load

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

Re: How to remove $symbol from Qlikview script?

prma7799 — Thu, 02 Nov 2017 06:19:53 GMT

Try this

PurgeChar(Yourfield,'$') as Newfield

KeepChar(Yourfield,1234567890) as Newfield

Re: How to remove $symbol from Qlikview script?

dolly777 — Thu, 02 Nov 2017 06:28:03 GMT

Thank you very much it is working fine:)

Re: How to remove $symbol from Qlikview script?

tresB — Thu, 02 Nov 2017 06:37:46 GMT

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

Re: How to remove $symbol from Qlikview script?

Ankit1988 — Fri, 28 Oct 2022 06:33:09 GMT

Hi try and its work