topic Re: Conditions in QlikView

Conditions

Tue, 04 Nov 2014 14:08:51 GMT

how can i make two 'if' condition in a text object for exemple:

=if(a>b,'OK','NO')

and

=if(c>d,'OK','NO')

rubenmarin — Tue, 04 Nov 2014 14:10:50 GMT

Hi, if you need both conditions it should be:

=if(a>b and c>d,'OK','NO')

its_anandrjs — Tue, 04 Nov 2014 14:11:15 GMT

You want this two as single if so

if(a>b,'OK','NO',

if(c>d,'OK','NO'))

Regards

Anand

anbu1984 — Tue, 04 Nov 2014 14:11:16 GMT

='a>b:' if(a>b,'OK','NO') & '- c>d:' & if(c>d,'OK','NO')

its_anandrjs — Tue, 04 Nov 2014 14:16:36 GMT

In load script create another field like

LOAD if( (a>b) ,'OK',

if( (c>d) ,'OK','NO')) as Details,a,b,c,d;

LOAD * Inline

[

a,b,c,d

1,2,1,2

];

Or in any text object write expression

=if( (a>b) ,'OK',

if( (c>d) ,'OK','NO'))

Regards

Anand

Tue, 04 Nov 2014 14:27:06 GMT

anbu1984 — Tue, 04 Nov 2014 14:29:15 GMT

='a>b:' if(a>b,'OK','NO') & If(a<b,'- c>d:' & if(c>d,'OK','NO'))