10 Replies Latest reply: Feb 9, 2017 4:54 PM by Sunny Talwar

# if(match with certain fields + Null

Hi All,

Im trying to do an if(match) that pulls in certain fields plus the null values. Is there a way to do this?

so it would if match for fields A,B,C and the nulls

Thanks,

• ###### Re: if(match with certain fields + Null

May be this:

If(Match(Field, A, B, C) or If(Len(Trim(Field)) = 0, True Condition, False Condition)

• ###### Re: if(match with certain fields + Null

If(Match(Field, 'A', 'B', 'C') and isnull(Field), True Condition, False Condition)

Sachin

• ###### Re: if(match with certain fields + Null

How can be field be A and Null at the same time? Do you mean this?

If(Match(Field, 'A', 'B', 'C') or isnull(Field), True Condition, False Condition)

• ###### Re: if(match with certain fields + Null

Yeah true..

• ###### Re: if(match with certain fields + Null

Even this would work I guess:

If(Match(Field, 'A', 'B', 'C', '-'), True Condition, False Condition)

Because Qlikview treats null as '-' ..Try and let us know pls..

• ###### Re: if(match with certain fields + Null

Hi,

'-' will ths work?? Bcs if it's in expression hope it ll work..

But in script I don't think so..As thr is possibility of it to work in expression as set works on result set and in tht case Qlik has already treated null() as '-'.. Thanks

• ###### Re: if(match with certain fields + Null

Hello Sachin, I am sure you got that understanding. Still just wanted to mention that here

AND

OR operators i used to get confused. To explain

AND -> Will explicitly check if both the expressions are true then True Condition will be satisfied.

OR  -> If any one of the expression are true then True Condition will be satisfied.

Hope i am clear. Correct me Sunny if not.

• ###### Re: if(match with certain fields + Null

U r ryt..

And checks fr all expression btn it to satisfy then only it will return true..

Fr or if any one satisfied also true .. Thanks

• ###### Re: if(match with certain fields + Null

Hi sunny,

I need one help..Do u have any doc or videos on "how we recommend Qlikview server configuration?"

If so plss send it across my email..Thanku

• ###### Re: if(match with certain fields + Null

Unfortunately I don't... I don't have much expertise in Server side...