topic Re: List box with filter condition in QlikView

List box with filter condition

ramasaisaksoft — Tue, 13 Jan 2015 06:17:30 GMT

Hi Team,

i have a list box with numbers and characters ex :-(1,2.3.4,5,~71,@89....ant,ball,cat,donkey,ele...etc) like this i have > 17000 records but characters words are only 95 records so i want to show those 95 in UI for end user

Now my query is there any way to show only characters

In advance thanks for your valuable help.

Re: List box with filter condition

anbu1984 — Tue, 13 Jan 2015 06:28:45 GMT

Try this expr in listbox

=If(Len(PurgeChar(Field,'0123456789')) = Len(Field) , Field)

Re: List box with filter condition

Anonymous — Tue, 13 Jan 2015 06:39:04 GMT

Hello Rama Sai,

Could you post sample records?

Ravi N.

Re: List box with filter condition

arulsettu — Tue, 13 Jan 2015 06:39:33 GMT

hi try this

=KeepChar(field,'abcdefghijklmnopqrstuvwxyz')

Re: List box with filter condition

MarcoWedel — Tue, 13 Jan 2015 06:48:33 GMT

KeepChar(field, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ')

Re: List box with filter condition

ramasaisaksoft — Tue, 13 Jan 2015 07:07:40 GMT

Thanks to all i got the solution like this

=If(IsNum([Department Name]) <> -1 And Len(PurgeChar([Department Name],'0123456789')) = Len([Department Name]) , [Department Name])

Appreciate every one individually.

Re: List box with filter condition

anbu1984 — Tue, 13 Jan 2015 07:13:24 GMT

Can you close the post by marking correct/helpful answers