Drop down values based on other drop down

reaa1234 — Tue, 22 Jan 2019 07:39:53 GMT

Hi,

I am trying to have two drop downs - Product Category and List of Products for my QlikSense app. I wish to limit drop down values in List of Products based on the selected Product Category. In this other query Set items on a drop down based on selected item in another drop down, they have manually set each dependent field value, can I somehow pick the values directly from the loaded table?

Thank you

Re: Drop down values based on other drop down

pedrobergo — Wed, 23 Jan 2019 12:41:35 GMT

Hi Reaaa1234,

I´m think you just connect the two dimensions tables and the Associative Engine will be what you want. You can do that from a fact table or directly between them (Star Schema or Snow Flake).

After that, when you choose a value at the first dimension, the second automatic shows the possible values in white color, and the non-possible in the grey color, just simple like that. It´s called The Power of Grey. Se more at Qlik Associative Difference

If you want to hide the non-possible values, you will need to download some filter extensions at https://developer.qlik.com/garden like Climber Selection Bar.

[],

Pedro

topic Drop down values based on other drop down in App Development

Drop down values based on other drop down

Re: Drop down values based on other drop down