Using Like Operator In Set Analysis

[#1]

Hello,

I am trying to use the like operator in set analysis, I have a comment field  and I want to count the different comments like

=count(DISTINCT {<InteractionName={'Uncontactable','Uncontactable closed'},Comment={'*Uncontacted*','*Wrong Party*','*Invalid Number*','*Fax Number*'}>} Reference)

PFA.

[Miguel_Angel_Baeyens · Accepted solution]

Use double quotes in set analysis to perform a search, so instead of

Comment={'*Uncontacted*','*Wrong Party*','*Invalid Number*','*Fax Number*'}

use

Comment={"*Uncontacted*","*Wrong Party*","*Invalid Number*","*Fax Number*"}

[Miguel_Angel_Baeyens]

For what it's worth, more on set analysis quoting and examples on:

Re: Sets when NOT equal to

And the always-learn-something-new from our beloved HIC

QlikView Quoteology

[#4]

Thank you very much for the insight Miguel.