topic How to create filter using substring of List box in QlikView

How to create filter using substring of List box

kvr9 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to create filter using substring of List box

trdandamudi — Tue, 18 Sep 2018 11:59:03 GMT

In the list box select expression and use the below:

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

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

Re: How to create filter using substring of List box

kvr9 — Tue, 18 Sep 2018 12:56:44 GMT

Excellent Thirumala.

Thank you so much.

Re: How to create filter using substring of List box

trdandamudi — Tue, 18 Sep 2018 13:08:22 GMT

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.

Re: How to create filter using substring of List box

vishsaggi — Tue, 18 Sep 2018 14:02:45 GMT

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