if(match with certain fields + Null

[#1]

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,

[sunny_talwar]

May be this:

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

[sdmech81]

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

Sachin

[sunny_talwar]

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)

[sdmech81]

Yeah true..

[sdmech81]

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..

[vishsaggi]

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.

[sdmech81]

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

[sdmech81]

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

[sdmech81]

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