Skip to main content
Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for 
Search instead for 
Did you mean: 
kvr9
Creator
Creator

How to create filter using substring of List box

Hi Experts,

Have a concern in creating a filter. Below is the conditions which I'm looking for.

I have data in a list box,I need to consider a substring and extract 1st two letters and build a new filter.

TI- International  TL- Local and other for remaining data

Attached  is the qvw.

Kindly help me in identifying the issue.

Thanks.

1 Solution

Accepted Solutions
trdandamudi
Master II
Master II

In the list box select expression and use the below:

=Pick(WildMatch([Product status],'TI*','TL*')+1,'Other','TI-International','TL_Local') 

OR

=Pick(WildMatch([Product status],'TI*','TL*'),'TI-International','TL_Local')

View solution in original post

4 Replies
trdandamudi
Master II
Master II

In the list box select expression and use the below:

=Pick(WildMatch([Product status],'TI*','TL*')+1,'Other','TI-International','TL_Local') 

OR

=Pick(WildMatch([Product status],'TI*','TL*'),'TI-International','TL_Local')

kvr9
Creator
Creator
Author

Excellent Thirumala.

Thank you so much.

trdandamudi
Master II
Master II

You are welcome and if you think you got the answer can you please close the thread, so that it will be helpful for others.

vishsaggi
Champion III
Champion III

Just a small suggested may be you should have marked Thirumala's first response as correct rather than plain text reply. Will help other users when they reach this thread. 🙂