topic Re: If nested three conditions in QlikView

If nested three conditions

Anonymous — Thu, 30 May 2013 20:10:17 GMT

Hi,

I need create a dimension based on three conditions, I mean:

if(isnull(a) and isnull(b) and (not isnull(c), 'Z',

if((not isnull(a) and isnull(b) and isnull(c), 'Y')) as Dimension

This for seven cases. Always the same three fields in the conditions, always if is null or not null.

That code doesn't work in the script in Qlikview, neither:

if(isnull(a),

if(isnull(b),

if((not isnull(c)),'Z',

)

How I do that dimension in Qlikview?

Thanks. Regards.

Re: If nested three conditions

Anonymous — Thu, 30 May 2013 21:08:46 GMT

Hello,

if(

isnull(a) and isnull(b) and not isnull(c),

'Z',

if(

not isnull(a) and isnull(b) and isnull(c),

'Y'

)

Re: If nested three conditions

Sokkorn — Fri, 31 May 2013 01:42:45 GMT

Hi Romina,

I think there are some issue with your If statement

Romina Villa wrote:
Hi,
I need create a dimension based on three conditions, I mean:
if(isnull(a) and isnull(b) and (not isnull(c), 'Z',
if((not isnull(a) and isnull(b) and isnull(c), 'Y')) as Dimension

So can you try below one and let me know:

If(IsNull(a) and IsNull(b) and Not IsNull(c),'Z',

If(Not IsNull(a) and IsNull(b) and IsNull(c),'Y')) as Dimension;

....

Regards,

Sokkorn

Re: If nested three conditions

Anonymous — Fri, 31 May 2013 12:25:18 GMT

Hi,

That solutions doesn't work for me.

I've tried that what you say, Sokkorn, but that returns only the last value that I inserted in the code.

That's why I tried later with the parenthesis before nulls.

Thanks.

Re: If nested three conditions

er_mohit — Fri, 31 May 2013 12:49:41 GMT

Try this

if(match(a,'0') and match(b,'0') and match(c,'0'), 'Z','Y')

Re: If nested three conditions

Gysbert_Wassenaar — Fri, 31 May 2013 14:01:04 GMT

Try:

IsNullMap:

mapping load * inline [

ABC, Letter

000,S

001,P

010,Q

011,Y

100,R

101,X

110,Z

111,T

];

Load A,B,C, applymap('IsNullMap', -isnull(A)&-isnull(B)&-isnull(C)) as Dimension

from ...somewhere...;

Re: If nested three conditions

Anonymous — Wed, 12 Jun 2013 12:51:34 GMT

That works!

Thank you.

Regards.