I need to create a dashboard that includes the information showed here (boxes 1, 5, and 9 are filters):
However, I’m not sure if the following scenario is possible:
First, I would like to select a country, which will update boxes 2, 3, 4, 5, 6, 9, 10. Then I want to select a plant in that country, which should only update 6, 7, 8, 9, and 10. Lastly, I need to select a product manufactured in that plant so that boxes 10, 11, and 12 change accordingly. In summary, selecting a plant shouldn’t affect the first row of the dashboard and selecting a product shouldn’t affect the first two rows. As a result the dashboard will present the summarized information for a selected country, plant, and individual product.
I hope this is somehow possible. Thank you very much!
You could create all the different objects making use of the Trellis option. This would split the analysis by the relevant dimensions you have.
Alternatively, you could use containers (and container within containers ) get the desire view that you are looking for. However, I do agree with Christopher in that it is counter intuitive to the way Qlik works.
Neither Trellis charts nor Containers are available in Sense!
It would be far better to educate your users to understand how the data is associated in Sense, and the relevance of the Green White and Grey selections rather than working around the logic inherent in Qlik.
It seems to be working fine. The dashboard shows information per country, plant, and product and e.g. selecting a material updates only the last row of the dashboard, but does not change the first and the second. Thanks again!