topic Set Analysis Not In in QlikView

Set Analysis Not In

Fri, 13 Apr 2012 20:20:31 GMT

I have a listbox of hundreds of values. I want to do a set analysis that says not value1 = x. It seems like its easy to do make it equal but I can't figure out how to do a != type of thing or not in ('myvalue').

Set Analysis Not In

Fri, 13 Apr 2012 20:24:04 GMT

{<value-={x}>}

Set Analysis Not In

rajni_batra — Mon, 16 Apr 2012 06:38:08 GMT

{<value<>{'x'}>}

Set Analysis Not In

CELAMBARASAN — Mon, 16 Apr 2012 09:03:51 GMT

Hi,

-= is to represent not equal in set analysis

Sum({<value1-={'x'}>} FieldName)

Celambarasan