topic Set analysis in QlikView

Set analysis

tizianacaem — Thu, 23 Sep 2010 11:37:57 GMT

Hi all,

I'd like to convert this expression with the set analysis syntax,

Any suggestions please?

Thanks

Tiziana

Thu, 23 Sep 2010 11:48:58 GMT

I remember reading somewhere that set analysis always uses "and" logic so I'm not sure whether this is possible. I could be wrong though!

I don't see what's wrong with if(field1 <> 'S' or field2 = 'L', field3 - field4, field5) no need to use sum here.

Thu, 23 Sep 2010 11:54:23 GMT

Hi,

Easier way to write your condition is-

IF(Field1<>'S' OR Field2='L', Sum(Field3-Field4),Field5)

With SET Analysis, you cannot have "OR"; its "AND".

Happy Thoughts