topic Re: Num format in QlikView

Num format

Mon, 15 Jun 2015 17:22:43 GMT

I have texts with ceros

For example

000031212

00000000000003131

00023232

0000444

I wanna do a 'num' but i wanna ignore the ceros. In this examples i'd like to see

31212

3131

23232

444

I don't know the length of the codes or the ceros

Thank you

Greetings

Re: Num format

sunny_talwar — Mon, 15 Jun 2015 17:25:15 GMT

May be like this:

Num(Num#(NumberField, '#')) as NumberField

Re: Num format

sunny_talwar — Mon, 15 Jun 2015 17:26:15 GMT

Tried it with this as an expression in text box object:

=Num(Num#('000031212', '#'))

and got the following output:

I hope this helps.

Best,

Sunny

Re: Num format

Mon, 15 Jun 2015 17:27:35 GMT

This worked

Thanks

replace(ltrim(replace(field , '0', ' ')), ' ', 0)

Re: Num format

Mon, 15 Jun 2015 17:28:48 GMT

that worked too

Re: Num format

sunny_talwar — Mon, 15 Jun 2015 17:31:57 GMT

I was thinking of using PurgeChar or Replace, but it would replace or purge any 0 from the number also. For example if you have 00000321203 -> output will be 32123 instead of 321203