topic Remove zeros from field in QlikView

Remove zeros from field

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How to remove zeros from field.

Field values: 002,003,004,005,055,088,099.

Please let me know how to remove those zeros from backend.

Thanks..

Re: Remove zeros from field

annafuksa1 — Fri, 03 Mar 2017 17:00:11 GMT

try

=SubField(Field , '0' ,-1)

Re: Remove zeros from field

annafuksa1 — Fri, 03 Mar 2017 17:03:50 GMT

in a script

num(Field)

Re: Remove zeros from field

Fri, 03 Mar 2017 17:26:51 GMT

As anna mentioned used num(Feild) if you want to trim the starting 0's
Just in case if you want to don't have zeros at all use PurgeChar(Feild,'0')

Re: Remove zeros from field

Anil_Babu_Samineni — Fri, 03 Mar 2017 17:40:04 GMT

May be use, I am assuming you may need 2,3,4,5,55,88,99

FieldName * 1 as FieldName

Re: Remove zeros from field

TiagoCardoso — Fri, 03 Mar 2017 17:53:44 GMT

Hi, sorry for my bad english. I'm brazilian....

In your load script, try this:

PurgeChar([Your Field], '0') AS [Your Field]

In text box, try this too...

=PurgeChar('001230','0')

its returns '123'

As you can see, the function works in both script and expressions.

I hope it can be helpful.

tiagocardoso‌

Re: Remove zeros from field

jonas_rezende — Fri, 03 Mar 2017 18:29:57 GMT

Hi, nareshthavidishetty nareshthavidishetty.

Utilize the function num(). Example:

LOAD

num(FieldName) as FieldName

From

<TableName.qvd>

(qvd);

Hope this helps!

Jonas Melo.

Re: Remove zeros from field

MarcoWedel — Sat, 04 Mar 2017 22:42:15 GMT

Hi,

you already received multiple correct answers when posting the same question a few weeks ago:

Trim zeros

Please describe the issue you are still having with the implementation.

If your question is answered however, then please close both threads related to this issue as well as your other threads that received correct answers:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

Re: Remove zeros from field

muthukumar77 — Mon, 06 Mar 2017 06:08:40 GMT

Hi,

Use Num(Field)

Re: Remove zeros from field

Chanty4u — Mon, 06 Mar 2017 06:30:14 GMT

keepchar(FieldName,'123456789') as New;