Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm trying to create a straight table which shows keyword likeness to search terms. E.g. search term = apple, keyword = apple.
I want the table to show all values as well as state in a separate field whether the search term and keyword match with a true/false statement.
Fields are as follows; [Search term], [Match type], Keyword
I've tried this expression: if([Search term] >= Keyword,1) with no luck.
Any help is much appreciated. Thanks in advance.
Mmm... try switching the formula to:
=if( [Search term] LIKE '*' & Keyword & '*' or Keyword LIKE '*' & [Search term] & '*', 1, 0)
And then in the presentation tab, uncheck 'Suppress Zero-Values':
you can use the = condition if you expect the string as the whole field or use substringcount function if part of the field
SubStringCount - script and chart function ‒ QlikView
You could try creating a chart with [Search term] and [Keyword] as dimensions, and add the following as an expression:
=if( [Search term] LIKE '*' & Keyword & '*' or Keyword LIKE '*' & [Search term] & '*', 1)
Thanks for this. Seems to have got me about half way there! So now it is showing all the terms which have a LIKE match, but need to also see the terms which do not match (these are keyed so can be differentiated). I've tried placing 'NOT' after the 'IF(' but that doesn't seem to work. Any ideas? Thanks.
Current result:
Mmm... try switching the formula to:
=if( [Search term] LIKE '*' & Keyword & '*' or Keyword LIKE '*' & [Search term] & '*', 1, 0)
And then in the presentation tab, uncheck 'Suppress Zero-Values':