Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

How to interpret * in your data

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.

2 Solutions

Accepted Solutions
MVP & Luminary
MVP & Luminary

=WildMatch(TableA.Indicator, TableB.Indicator)

-Rob

View solution in original post

MVP & Luminary
MVP & Luminary

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

View solution in original post

4 Replies
MVP & Luminary
MVP & Luminary

=WildMatch(TableA.Indicator, TableB.Indicator)

-Rob

View solution in original post

Creator
Creator

Thank you Rob.

Creator
Creator

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

MVP & Luminary
MVP & Luminary

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

View solution in original post