Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is there a way to exclude data in a list box?

For example: 

Example List Box1
32578977
34562877

23125967

I need to look up last 2 digits for my exclusion and my exclusion criteria is 77
So the List Box should only show:
23125967
1 Solution

Accepted Solutions
Not applicable
Author

for that make the list box use an expression:

if(right(yourfield,2)<>'77',yourfield)

View solution in original post

2 Replies
Not applicable
Author

for that make the list box use an expression:

if(right(yourfield,2)<>'77',yourfield)

Not applicable
Author

Thanks!