topic Re: Issue in if condition for excluding? in QlikView

Issue in if condition for excluding?

Mon, 29 Jun 2015 16:29:25 GMT

Hi,

How do I write the if condition for excluding?

PCR = {111,1117,123,134}
Say if I want to include {111,1117} in my report

I would wite it as if(match(PCR,111,1117))

But how do I write the same if I want to exclude?
Can someone please tell me the opposite expression for match?

Thanks in advance.

Reagrds,
Sachin

swuehl — Mon, 29 Jun 2015 16:32:58 GMT

if( not match(PCR,111,1117), ThenBranch, ElseBranch)

Mon, 29 Jun 2015 16:37:57 GMT

I tried but not match is not getting recognized as a function.

sunny_talwar — Mon, 29 Jun 2015 16:40:05 GMT

There needs to be a space between not and match:

the text for not and match turned blue mean they are getting recognized as functions.

HTH

Best,

Sunny

ramoncova06 — Mon, 29 Jun 2015 16:41:16 GMT

if you are creating a calculated expression you could use concat or only combined with aggr

something like

aggr(concat({<PCR -={111,1117,123,134}>}PCR), PCR)

swuehl — Mon, 29 Jun 2015 16:41:56 GMT

Do you get an error telling so?

I believe it should work, but you can also use:

if( match(PCR,111,1117)=0, ThenBranch, ElseBranch)