topic Re: List box expression bit tricky in QlikView

List box expression bit tricky

Thu, 16 Jul 2015 17:28:37 GMT

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.

Re: List box expression bit tricky

Gysbert_Wassenaar — Thu, 16 Jul 2015 17:35:49 GMT

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

Re: List box expression bit tricky

Thu, 16 Jul 2015 19:12:29 GMT

its worked

thanks for your support Wassenaar.