topic Match function fails in QlikView

Match function fails

Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

i tried below edit script code for getting the data which not having the Coveo and DotNet. But it is not displaying the result what expected.

Please can anyone what should be done to achieve.

Let vT1 = Coveo | DotNet;

LOAD * Inline

Android

IPhone

QlikView

Coveo

DotNet]

Where not Match(A,'$(vT1)');

Thanks in advance.

Regards

Veer

Match function fails

CELAMBARASAN — Wed, 25 Apr 2012 18:28:41 GMT

Hi,

Check with it

Let vT1 = chr(39)&'Coveo'&chr(39)&','&Chr(39)&'DotNet';

LOAD * Inline

Android

IPhone

QlikView

Coveo

DotNet]

Where not Match(A,$(vT1));

Match function fails

jonathandienst — Wed, 25 Apr 2012 20:08:34 GMT

Just change your Let statement to a Set statement.

Set vT1 = Coveo | DotNet;

Regards

Jonathan

Re: Match function fails

Thu, 26 Apr 2012 09:42:22 GMT

Hi Celambarasn,Jonathan

i tried both of your reply codes but generating an error message "Error in expression: ')' expected".

Is there any better way to work it ?

Thanks in advance.

Regards,

Veer

Re: Match function fails

CELAMBARASAN — Thu, 26 Apr 2012 09:44:47 GMT

Hi,

Missed one in that.Check with this

Let vT1 = chr(39)&'Coveo'&chr(39)&','&Chr(39)&'DotNet'&chr(39);

Re: Match function fails

Thu, 26 Apr 2012 10:03:05 GMT

Hi Celambrasan,

Its working fine , before we worked on providing the Let statement in script.

Now the values should be change dynamically by variable.

variable : vT1

value : =GetFieldSelections(A,chr(39)&','&chr(39))

It display the result Coveo','DotNet but i needs to get the result like 'Coveo','DotNet'

Please suggest how the expression should change to achieve this.

Thank in advance.

Match function fails

CELAMBARASAN — Thu, 26 Apr 2012 10:05:54 GMT

Hi,

Check with this

chr(39)&GetFieldSelections(A,chr(39)&','&chr(39))&chr(39)

GetFieldSelections(Chr(39)&A&Chr(39),',')

Re: Match function fails

Thu, 26 Apr 2012 10:13:26 GMT

Hi First expression works fine.

Thanks for your great response.

Regards

Veer

Re: Match function fails

Thu, 26 Apr 2012 10:15:12 GMT

Hi Celambarasan,

i had a doubt in new concept i.;e Named CAL's.

Please can i share this with you on same post or in new post ?

Thanks in advance.