Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
May be this:
If(Match(Field, A, B, C) or If(Len(Trim(Field)) = 0, True Condition, False Condition)
If(Match(Field, 'A', 'B', 'C') and isnull(Field), True Condition, False Condition)
Sachin
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)
Yeah true..
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..
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.
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
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
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