Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using Like Operator In Set Analysis

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.

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

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*"}


View solution in original post

3 Replies
Miguel_Angel_Baeyens

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*"}


View solution in original post

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

Not applicable

Thank you very much for the insight Miguel.