topic Re: if(match with certain fields + Null in QlikView

if(match with certain fields + Null

Thu, 09 Feb 2017 15:01:17 GMT

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

sunny_talwar — Thu, 09 Feb 2017 15:06:59 GMT

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

sdmech81 — Thu, 09 Feb 2017 15:25:28 GMT

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

Sachin

Re: if(match with certain fields + Null

sunny_talwar — Thu, 09 Feb 2017 15:26:28 GMT

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

sdmech81 — Thu, 09 Feb 2017 15:34:12 GMT

Yeah true..

Re: if(match with certain fields + Null

sdmech81 — Thu, 09 Feb 2017 15:38:09 GMT

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

vishsaggi — Thu, 09 Feb 2017 15:40:28 GMT

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

sdmech81 — Thu, 09 Feb 2017 15:41:34 GMT

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

sdmech81 — Thu, 09 Feb 2017 15:59:27 GMT

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

sdmech81 — Thu, 09 Feb 2017 16:02:21 GMT

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

sunny_talwar — Thu, 09 Feb 2017 21:54:39 GMT

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