topic Re: List box only need alphabetic in QlikView

List box only need alphabetic

everest226 — Tue, 17 Apr 2018 16:02:33 GMT

HI i have a list box with numerical and alphabetical value, how to show only alphabetical value.

asd

hsbd

dfd

251

152544

sdfd

Re: List box only need alphabetic

sunny_talwar — Tue, 17 Apr 2018 16:04:11 GMT

May be this

If(IsText(Field), Field)

Re: List box only need alphabetic

vishsaggi — Tue, 17 Apr 2018 16:08:09 GMT

May be this?

In your listbox General tab -> Field - Expression

= IF(ISNUM(Alphabet), Null(), Alphabet)

OR

= IF(NOT IsNum(Alphabet), Alphabet)

Re: List box only need alphabetic

everest226 — Tue, 17 Apr 2018 16:19:04 GMT

Thanks both of you it worked.

Re: List box only need alphabetic

Chanty4u — Tue, 17 Apr 2018 16:46:17 GMT

may be try this way

a:

LOAD*, PurgeChar(MyField,'01234567890') as New;

LOAD * INLINE [

MyField

asd

hsbd

dfd

251

152544

sdfd

];