Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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,

10 Replies
sunny_talwar

May be this:

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

sdmech81
Specialist
Specialist

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

Yeah true..

sdmech81
Specialist
Specialist

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
Champion III
Champion III

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

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

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

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