topic Remove selected value from list box in QlikView

Remove selected value from list box

Mon, 04 Oct 2010 13:20:40 GMT

Hi All,

I got two list boxes which are not related.

ListboxA ListBoxB

A A1

B B1

C C1

When I choose A in listboxA ListBox B should display B1 and C1; Choosing B in LisboxA should have a display A1 and C1 in listboxB.

I make this work using macro. Is there any way to solve this without using macro?

Thanks,

Nadsky

Mon, 04 Oct 2010 13:45:52 GMT

Did you already tried dome link table?

Mon, 04 Oct 2010 13:51:20 GMT

Hi Ramunas,

Thanks for the response. Sorry but I don't know how to create a dome link table. .

I'm wondring if this can be solve by expressions?

Thanks

Anonymous — Mon, 04 Oct 2010 14:01:47 GMT

Nadsky,
It can be done using list box with expression:
=aggr(only({1-$} ListBoxB),ListBoxB)

Mon, 04 Oct 2010 14:04:59 GMT

Hi,

You can use a "EDIT EXPRESSION" and filtering whith a function "LIKE"

See the example.

Mon, 04 Oct 2010 14:18:41 GMT

Hi Eduardo,

Wow! you solutions works!

A big thanks to you!

Regards,

Nadsky