List Box - Filter Selections

[jmonroe918]

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.

[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]

Sunny:

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

Jeff

[maxgro]

maybe a listbox with this expression

=if(Select='X',Issue)

[jmonroe918]

max:

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

Thanks.

Jeff

[sudeepkm · Accepted solution]

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

[maxgro]

yes thanks

and the result is

[jmonroe918]

max:

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

Jeff