topic Re: List Box - Filter Selections in QlikView

List Box - Filter Selections

jmonroe918 — Fri, 18 Sep 2015 00:14:28 GMT

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 — Fri, 18 Sep 2015 01:18:38 GMT

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 — Fri, 18 Sep 2015 15:31:28 GMT

Sunny:

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

Jeff

maxgro — Fri, 18 Sep 2015 17:06:17 GMT

maybe a listbox with this expression

=if(Select='X',Issue)

jmonroe918 — Fri, 18 Sep 2015 18:06:23 GMT

max:

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

Thanks.

Jeff

sudeepkm — Fri, 18 Sep 2015 18:21:30 GMT

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 — Fri, 18 Sep 2015 18:44:56 GMT

yes thanks

and the result is

jmonroe918 — Fri, 18 Sep 2015 20:47:48 GMT

max:

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

Jeff