topic Set analysis replacing IF (with AND OR (AND .. OR ..) etc) in QlikView

Set analysis replacing IF (with AND OR (AND .. OR ..) etc)

RSvebeck — Thu, 29 Mar 2012 08:15:58 GMT

Hello all

I'm building a dashboard and need to convert some tricky IF conditions into SET Analysis.

List all green items (see attached picture for example):

IF (F2=A AND (F1=N OR F1=M)) OR
(F2=B) OR
(F2=C) OR
(F2=D AND F1=P)

then ...

I've attached a picture where my example data is visualized in a simple way (green and white items).

Regards, Robert

erichshiino — Sun, 01 Apr 2012 21:49:12 GMT

Hi, Robert

I don't know you other fields, but let us say that you are trying to sum VALUE

You can use set analysis to operate with different sets

you expression could be:

sum ( { <F2={A}, F1={N,M}>+<F2={B}>+<F2={C}>+<F2={D}, F1={P}>} value)

Hope this helps,

Erich

Clever_Anjos — Mon, 02 Apr 2012 12:15:23 GMT

Maybe you should avoid so complicated expressions in Set Aanalysis.

I would create a field in script time e use this flag as a Set Analysis expression filter