Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
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
Highlighted
MVP & Luminary
MVP & Luminary

=WildMatch(TableA.Indicator, TableB.Indicator)

-Rob

View solution in original post

Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

=WildMatch(TableA.Indicator, TableB.Indicator)

-Rob

View solution in original post

Highlighted
Creator
Creator

Thank you Rob.

Highlighted
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

Highlighted
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