topic Set analysis help in QlikView

Set analysis help

alan_grn — Thu, 07 Oct 2010 04:30:28 GMT

I am trying to do the following. COuld you please help with the set analysis.

IF FIELD1 value <> 'text value' then sum fieldvaue2 where fieldvlaue3 <> 'a value'

Thu, 07 Oct 2010 04:37:33 GMT

HI,

Try this:


If(Field1 <> 'text value', sum({$<Field3 -= {'a value'}>} Field2))

Regards

Miguel_Angel_Baeyens — Thu, 07 Oct 2010 07:11:46 GMT

Hello,

Just going one step further, I'd include all conditional in set analysis. It shuould work and perform better

sum({$< Field1 -= {'text value'}, Field3 -= {'a value'} >} Field2)

Regards.