topic Re: List Box used to Filter Dimensions in QlikView

List Box used to Filter Dimensions

EGilbert — Sat, 16 Nov 2024 19:30:57 GMT

In the above example how would I use a list box to select the product ID and have the chart show just the plants that make that product, but show the whole plant look so all products and open capacity. In essence use the product ID in the list box as a filter for what plant dimension values to display, but not impact the product detail data in the sum expression?

I would like to select 'Product D' in a list box and get the below results that show only Plants 2 & 4 but all products and open capacity at those plants

Re: List Box used to Filter Dimensions

wade12 — Tue, 17 Dec 2019 16:52:36 GMT

if it is really so straight-forward, why not just have a plant listbox.

a user can clearly see the first chart and identify that plants 2 & 4 have product d,

then user can just select plants 2 & 4 from the plant listbox

-> and then you should have your answer

... just a suggestion.

Re: List Box used to Filter Dimensions

EGilbert — Tue, 17 Dec 2019 17:16:11 GMT

The concern is that we have 40+ plants and even more product types and I would like users to be able to select a product they are interested in and get a chart of all the plants that make that product, without having to select or even know all of them.

Thanks for the comments