Set analysis help needed?

siva_boggarapu — Thu, 31 May 2012 12:34:33 GMT

Hello Everyone,

Let say I have one list box which is containng number of Values like below

FIELD

AAA

BBB

CCC

DDD

EEE

FFF

GGG

HHH

III

JJJ

KKK

LLL

MMM

NNN

Here, my question is how can i show only 'AAA','BBB','CCC' values only using set analysis. Rest of values should not visible.

Best,

Siva.

swuehl — Thu, 31 May 2012 12:47:08 GMT

Select <expression> from the field list drop down in the list box properties and try something like

=aggr(only({<FIELD={AAA,BBB,CCC}>} FIELD),FIELD)

topic Set analysis help needed? in QlikView