How to interpret * in your data

[waleeed_mahmood]

Hello,

I have two tables that i read from SQL. Table A and Table B both have a field called Indicator. However, in Table A, Indicator contains some text "ABC" but in Table B, Indicator contains a wildcard (*) meaning it should match everything. I want to compare  and see if Table A.Indicator=Table B.Indicator and the result should be a yes because anything and everything compared to Table B.Indicator should match because of the WildCard. How can i do this in Qlik Sense?

Table A:                                   Table B:

Indicator                                 Indicator

ABC                                            *

DEF                                            *

Thank you for your help.

[rwunderlich · Accepted solution]

=WildMatch(TableA.Indicator, TableB.Indicator)

-Rob

[waleeed_mahmood]

Thank you Rob.

[waleeed_mahmood]

Hi Rob,

I tried your solution with the following code and it doesnt work. $(oM_ProIndic) is a variable that i store Table A.Indicator in. What am i doing wrong in this case?

if (Wildmatch($(oM_ProIndic), '*')) then

[rwunderlich · Accepted solution]

If using a variable value, you'll need single quotes around the string. 

if (Wildmatch('$(oM_ProIndic)', '*')) then

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com