topic Re: feild num without zero in QlikView

feild num without zero

Anonymous — Wed, 20 Apr 2016 03:08:31 GMT

hi,

i have feild with 6 numeric position.

in some case the num start with zero.

exm:

000353 = 353

003303 = 3303

061498 = 61498

000101 = 101

....

how do i chenge it to numeric feild without the zero at start?

thanks'

yarin.

Anonymous — Wed, 20 Apr 2016 03:22:03 GMT

Hi,

Try this:

=REPLACE(LTRIM(replace(Column, '0', ' ')),' ',0)

Hope it helps!!

tamilarasu — Wed, 20 Apr 2016 03:22:43 GMT

Hi Yarin,

Try,

Num(FieldName) (If your field is text then try => Num(Num#(FieldName,'#')) )

=Replace(Ltrim(replace(FieldName,'0',' ')),' ','0')

Anonymous — Wed, 20 Apr 2016 03:40:06 GMT

thanks' it's good.

yarin.

Anonymous — Wed, 20 Apr 2016 04:28:49 GMT

I am glad to help!!