topic Re: Dynamic List Boxes, change based on table selected in container. in QlikView

Dynamic List Boxes, change based on table selected in container.

Tue, 23 Sep 2014 16:38:58 GMT

I want to set up some List Boxes that change to certain fields based on which table is selected in a container. I have for example Table 1, Table 2 and Table 3 in my container.

Lets say they each have a Create Date column/field, they are not linked but I want that list box to show the create date specific to each table. If I select Table 1 the list box should display Table 1's Create date, and if I clink on Table 2 the list box should update and show the Create date of that table.

Thank you,

Alam

Re: Dynamic List Boxes, change based on table selected in container.

ecolomer — Tue, 23 Sep 2014 16:52:54 GMT

Here you have an example for Dinamic List:

Re: Dynamic List Boxes, change based on table selected in container.

maxgro — Tue, 23 Sep 2014 16:54:14 GMT

replace container with 3 charts and use button to display chart and listbox: in button you can set a variable (1,2,3) and use that variable to conditionally show/hide chart and listbox

use a single object container with 3 grid container inside

every grid container has the chart and the listbox for that chart

Re: Dynamic List Boxes, change based on table selected in container.

emiledavis — Wed, 01 Jul 2015 15:35:50 GMT

This is exactly what I've been looking for! At first, the caption on the dynamic list box wasn't working. I ended up using =Only([$Field]) as the caption. Works like a charm. Thanks for posting!

Re: Dynamic List Boxes, change based on table selected in container.

saimahasan — Mon, 05 Sep 2016 15:24:24 GMT

If your query has been resolved then please mark the discussion as closed.