topic Re: syntax error in expression in QlikView

syntax error in expression

Wed, 21 Aug 2013 11:27:16 GMT

Hi,

I have one field value 'Supervisor's Opinion. when I am trying to use this MixMatch I am getting syntax error. could anyone tell mw how can I write this without error.

if(MixMatch([Error Types],'Supervisor's Opinion'

Re: syntax error in expression

vikasmahajan — Wed, 21 Aug 2013 11:32:17 GMT

Please type your expression to help you better , you are giving incomplete information , While posing in community you should create dummy qvw along with your post so that other person can help you soon..................

vikas

Re: syntax error in expression

tresB — Wed, 21 Aug 2013 11:35:58 GMT

If you are using the braces properly, then this could be because of the single quote in the string.

Re: syntax error in expression

er_mohit — Wed, 21 Aug 2013 11:39:30 GMT

try this way

=Count({<[Error Types]={"Supervisor's Opinion"}>}[Error Types])

or try this way

if(MixMatch([Error Types],'Supervisor'&chr(39) &'s' &' ' & 'Opinion'),your expression)

Re: syntax error in expression

Wed, 21 Aug 2013 11:39:44 GMT

try this

MixMatch([Error Types],'Supervisor & chr(39) & 's Opinion')

***********************************

The mixmatch function performs a case insensitive comparison.

Example:

mixmatch( M, 'Jan','Feb','Mar')

returns 1 if M = jan

*************************************

Re: syntax error in expression

Wed, 21 Aug 2013 11:45:32 GMT

try chr(39) in

MixMatch([Error Types],'Supervisor & chr(39) & 's Opinion')

Re: syntax error in expression

nizamsha — Wed, 21 Aug 2013 12:11:59 GMT

Load * inline [

Country

AUSTRALIA

INDIA

];

=MixMatch(COUNTRY,'AUSTRALIA','INDIA',US)

if the string AUSTRALIA,INDIA,US matches the country then it will return one else it will return o

Re: syntax error in expression

Wed, 21 Aug 2013 13:17:25 GMT

Not sure, if it is the actual mistake, but in the case the formula is correct don't forget to close the brackets, so

=if(MixMatch([Error Types],'Supervisor's Opinion'))