topic Set analysis - Need Help plz in QlikView

Set analysis - Need Help plz

Thu, 01 May 2014 11:54:43 GMT

Hi All,

I have to exclude abc value which comes in my field (A).

can i know how to do that plz??

thanks

Thu, 01 May 2014 12:01:48 GMT

try sum({<FieldA-={'abc'}>} amount)

Anonymous — Thu, 01 May 2014 12:04:34 GMT

i think it should be

sum({<[FieldA]-={'<>abc'}>} amount)

Anonymous — Thu, 01 May 2014 12:06:08 GMT

hi,

the -= operator in your set analysis should do the trick:

sum({<A-={abc}>}FieldName)

rgds

Artur

Joseph_Musekura — Thu, 01 May 2014 12:09:18 GMT

Hi,

This should return all values in FIELDA except 'abc' (within a selection)

sum( {$<FieldA = {“*”} – {'abc'} >} Value )

regards,