Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Match function fails

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

[A

Android

IPhone

QlikView

Coveo

DotNet]

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

Thanks in advance.

Regards

Veer

1 Solution

Accepted Solutions

Re: Match function fails

Hi,

     Missed one in that.Check with this

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

8 Replies

Match function fails

Hi,

     Check with it

    

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

LOAD * Inline

[A

Android

IPhone

QlikView

Coveo

DotNet]

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

MVP
MVP

Match function fails

Hi

Just change your Let statement to a Set statement.

Set vT1 = Coveo | DotNet;

Regards

Jonathan

Not applicable

Re: Match function fails

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

Hi,

     Missed one in that.Check with this

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

Not applicable

Re: Match function fails

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

Hi,

     Check with this

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

Or

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

Not applicable

Re: Match function fails

Hi First expression works fine.

Thanks for your great response.

Regards

Veer

Not applicable

Re: Match function fails

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.

Community Browser