Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Missed one in that.Check with this

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

View solution in original post

8 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

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));

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Just change your Let statement to a Set statement.

Set vT1 = Coveo | DotNet;

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

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

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Missed one in that.Check with this

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

Not applicable
Author

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.

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Check with this

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

Or

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

Not applicable
Author

Hi First expression works fine.

Thanks for your great response.

Regards

Veer

Not applicable
Author

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.