topic Re: Use of 'Not Match' function with a variable in QlikView

Use of 'Not Match' function with a variable

Anonymous — Wed, 16 Dec 2015 09:41:02 GMT

I have the following 'Not Match' function:

If( Not Match(_View, 'Patent Analytics' , 'FDA Analytics') , _View)

Can the string 'Patent Analytics', 'FDA Analytics' be replaced with a variable and use the variable in the function? If so, how can this be accomplished.

Regards.

Re: Use of 'Not Match' function with a variable

tamilarasu — Wed, 16 Dec 2015 09:49:11 GMT

Hi Christopher,

Try,

Variable Name: vList

Definition: 'Patent Analytics' , 'FDA Analytics'

= If(Not Match(_View,$(vList) ), _View)

Re: Use of 'Not Match' function with a variable

ahmar811 — Wed, 16 Dec 2015 09:50:52 GMT

hi Christopher Chitemerere‌

try this

create the variable like below

set vMatch='Patent Analytics' , 'FDA Analytics';

and write the condition like that using variable

If( Not Match(_View, $(vMatch)) , _View)

hope this help

Regards

Ahmar

Re: Use of 'Not Match' function with a variable

tresB — Wed, 16 Dec 2015 09:54:27 GMT

Define variable (say, vExclude) like : 'Patent Analytics','FDA Analytics'

Note, No '=' sign; ignore error red marks. Then :

If( Not Match(_View, $(vExclude)) , _View)

Re: Use of 'Not Match' function with a variable

Anonymous — Wed, 16 Dec 2015 10:44:15 GMT

THANK YOU

Re: Use of 'Not Match' function with a variable

Anonymous — Wed, 16 Dec 2015 10:44:42 GMT

Thank you Ahmar

Re: Use of 'Not Match' function with a variable

Anonymous — Wed, 16 Dec 2015 10:45:04 GMT

Tresses thank you