Count if one field contains text from other field

Anonymous — Sat, 16 Nov 2024 07:14:08 GMT

Hi all,

I need you help please with Qlik Sense.

I have two tables:

*note: REASON_CODE_SLOV could be a sentence and not just a one word.

I would like to create a pivot table that count if REASON_CODE_SLOV (from Table2) is in REASON_CODE_MLOV (from Table1).

For example:

What will be the function I should use to count the words/text from Table2 if Table1 contains them?

Re: Count if one field contains text from other field

Anonymous — Wed, 21 Nov 2018 20:09:47 GMT

Sum(If(WildMatch(Reason_Code_Mlov, '*'&Reason_Code_Slov&'*'), 1, 0))