Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List box expression bit tricky

i have a list box in the below qvw

in my scenario i have to Exclude or restrict the field values which are having starting letters 's','r','m','j' in salesman field whether it is upper or lower we should exclude those salesman names.

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can use this expression instead of a field: =if(not WildMatch(Salesman, 's*', 'm*', 'r*'),Salesman)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can use this expression instead of a field: =if(not WildMatch(Salesman, 's*', 'm*', 'r*'),Salesman)


talk is cheap, supply exceeds demand
Not applicable
Author

its worked

thanks for your support Wassenaar.