Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
everest226
Creator III
Creator III

List box only need alphabetic

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

asd

hsbd

dfd

251

152544

sdfd 

1 Solution

Accepted Solutions
sunny_talwar

May be this

If(IsText(Field), Field)

View solution in original post

4 Replies
sunny_talwar

May be this

If(IsText(Field), Field)

vishsaggi
Champion III
Champion III

May be this?

In your listbox General tab -> Field - Expression

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

OR

= IF(NOT IsNum(Alphabet), Alphabet)

everest226
Creator III
Creator III
Author

Thanks both of you it worked.

Chanty4u
MVP
MVP

may be try this way

a:

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

LOAD * INLINE [

MyField

    asd

    hsbd

    dfd

    251

    152544

    sdfd

];