Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
=WildMatch(TableA.Indicator, TableB.Indicator)
-Rob
Thank you Rob.
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
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