topic Re: Using Like Operator In Set Analysis in QlikView

Using Like Operator In Set Analysis

Mon, 28 Nov 2016 10:22:24 GMT

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.

Re: Using Like Operator In Set Analysis

Miguel_Angel_Baeyens — Mon, 28 Nov 2016 10:25:07 GMT

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

Re: Using Like Operator In Set Analysis

Miguel_Angel_Baeyens — Mon, 28 Nov 2016 11:05:30 GMT

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

Re: Using Like Operator In Set Analysis

Mon, 28 Nov 2016 11:11:56 GMT

Thank you very much for the insight Miguel.