Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
jmonroe918
Creator II
Creator II

List Box - Filter Selections

I am trying to create list-box that displays the field from records that contain data in another field. See below.

I only want the list-box to show Issue1 and Issue2, based on the X being the Select field. How is this possible

Select      Issue

X                Issue1

                  Issue2

X                Issue3

                  Issue4

I'm doing this to keep the list short, but the list available selections will change from time to time.

Thanks.

1 Solution

Accepted Solutions
sudeepkm
Specialist III
Specialist III

I think Max's suggestion was to put it as expression in the List box instead of selecting a field in the list box.

T181346.PNG

View solution in original post

7 Replies
sunny_talwar

I see a X next to Issue 1 and Issue 3. Did you mean to see Issue 1 and Issue 3 when you select X? or is the data like this?

Select,        Issue

X,               Issue1

X,               Issue2

Y,               Issue3

Y,               Issue4

jmonroe918
Creator II
Creator II
Author

Sunny:

I want to see only the records where there is an X. In this case Issue1 and Issue3.

Jeff

maxgro
MVP
MVP

maybe a listbox with this expression

=if(Select='X',Issue)

jmonroe918
Creator II
Creator II
Author

max:

I tried that with no success. Here's a pared down qvw of the data and list=-box.

Thanks.

Jeff

sudeepkm
Specialist III
Specialist III

I think Max's suggestion was to put it as expression in the List box instead of selecting a field in the list box.

T181346.PNG

maxgro
MVP
MVP

yes thanks

and the result is

1.png

jmonroe918
Creator II
Creator II
Author

max:

Now that I know where to put the formula it works great! Thanks so much for your (and Sudeep's) help.

Jeff