topic Multi conditional expression in QlikView

Multi conditional expression

Tue, 14 May 2013 08:20:41 GMT

Hello,

I want to do this, but if I understood correctly, it's not allowed to use AND and OR in expression.

I work with QV 10.

Have you an other solution ?

In expression ==>

= if(

(

(Comptabilite.type = 'QCO' OR Comptabilite.type = 'TER' OR Comptabilite.type = 'RIS') AND isnull(Comptabilite.dateregcom)

)

(

(Comptabilite.etat = 'S' or isnull(Comptabilite.etat)) AND not isnull(Comptabilite.dateregcom)

)

, sum(Comptabilite.primettc) - sum(Comptabilite.commission))

Thanks a lot,

Victor

jonathan_dau — Tue, 14 May 2013 09:20:06 GMT

Maybe you could try this one. Not sure though

if(

Comptabilite.type = 'QCO' OR

Comptabilite.type = 'TER' OR

Comptabilite.type = 'RIS' AND

isnull(Comptabilite.dateregcom),sum(Comptabilite.primettc) - sum(Comptabilite.commission),

if(

Comptabilite.etat = 'S' OR

isnull(Comptabilite.etat) AND

not isnull(Comptabilite.dateregcom), sum(Comptabilite.primettc) - sum(Comptabilite.commission)))

Jonathan

Tue, 14 May 2013 09:24:04 GMT

It give the same result