Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Master II
Master II

Re: How to create filter using substring of List box

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
Highlighted
Master II
Master II

Re: How to create filter using substring of List box

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

Highlighted
Creator
Creator

Re: How to create filter using substring of List box

Excellent Thirumala.

Thank you so much.

Highlighted
Master II
Master II

Re: How to create filter using substring of List box

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.

Highlighted
Champion III
Champion III

Re: How to create filter using substring of List box

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. 🙂