Discussion board where members can get started with QlikView.
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.
In the list box select expression and use the below:
View solution in original post
Thank you so much.
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.
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. 🙂