topic Re: conditions in QlikView

conditions

Wed, 05 Nov 2014 09:46:36 GMT

hi,

how can i execute this condition in qlikview:

if(A>B){

print('toto')

}else{

print('titi'),

}else if(D>J){

print(toto1)

}else{

print(toto2)

}

puttemans — Wed, 05 Nov 2014 09:52:20 GMT

Hi,

I think this is the logic you're trying to script.

IF( (A>B), (IF(D>J) toto1, toto2), titi);

If A>B then you look whether D>J to define the type of toto to print, if the first condition does not apply, you print titi.

Regards,

CELAMBARASAN — Wed, 05 Nov 2014 09:52:34 GMT

You have been asking on the Nested If,

Simple if:

If(condition, Expression for true, Expression for else)

If(condition, Expression for true, if(condition, Expression for true(else if part), Expression for false))

sujeetsingh — Wed, 05 Nov 2014 10:16:50 GMT

if(A>B 'toto',

if(D>J 'toto1','oto2'),'titi')

simenkg — Wed, 05 Nov 2014 10:21:14 GMT

in the script and you want to write to the "console"?

IF A > B THEN
Trace 'toto';

ELSEIF B<A THEN

Trace 'titi';

ELSEIF D>J THEN
Trace 'toto1';

ELSE

Trace 'toto2';

ENDIF

Wed, 05 Nov 2014 10:24:57 GMT

Try doing the test with the inverted logic:

if(A<=B,'titi',if(D>J,'toto1','toto2'))

Wed, 05 Nov 2014 10:31:31 GMT

thank you guys it works