Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siva_boggarapu
Creator II
Creator II

Set analysis help needed?

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.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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)

View solution in original post

1 Reply
swuehl
MVP
MVP

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)