topic Re: List Box? in QlikView

List Box?

prajapatiamar38 — Tue, 07 Jul 2015 07:20:17 GMT

Hi Community,

I have one inline table.

LOAD * INLINE [

00001234

000546

00000768

00007777

00005867

000qdsf

000bfn

0000abcd

000005464

80000000y

];

My requirement is i want to remove zeros and my output should be like this 1234,456,abcd,8000000y...

I want in list box only how can i do this..

Thanks

Re: List Box?

antoniotiman — Tue, 07 Jul 2015 07:31:16 GMT

Hi,

=Alt(Num(ID),If(Left(ID,1)=0,PurgeChar(ID,'0'),ID))

Regards,

Antonio

Re: List Box?

MayilVahanan — Tue, 07 Jul 2015 07:36:23 GMT

Try like this

LOAD *, Mid(ID, FindOneOf(ID, '123456789abcdefghijklmnopqrstuvwxyz')) as FinalID INLINE [

00001234

000546

00000768

00007777

00005867

000qdsf

000bfn

0000abcd

000005464

80000000y

];

Re: List Box?

krishna20 — Tue, 07 Jul 2015 07:42:45 GMT

Hi Try this,

=If(Left(ID,1)=0,PurgeChar(ID,'0'),ID)

it will works..

Re: List Box?

jonathandienst — Tue, 07 Jul 2015 07:46:15 GMT

=Alt(Num(ID), Replace(Trim(Replace(ID, '0', ' ')), ' ', '0'))

Re: List Box?

prajapatiamar38 — Tue, 07 Jul 2015 07:48:18 GMT

Thanks ANTONIO MANCINI,

Its really helpful.

Re: List Box?

antoniotiman — Tue, 07 Jul 2015 07:57:29 GMT

Thanks Amarnath,

I,m glad I was helpful.

Regards,

Antonio