Hi,
I have three controls, A (drop down), B (drop down), and C (free text). they are working fine as expected but I want to add feature if I type some values in C filter control, other control filter should also get affected and instead of showing all, it should show respective values.
Thanks
BS
Hi @SantoshB,
Are you looking for relevant values display even without filtering C?
If you mean, once you type is values in C and select filter values, A and B should show relevant values, then you can configure the same using show relevant values under control options.
If you are looking for value update without filtering C and only by typing as it appears in C, then I do not think it is possible to configure likewise.
Thanks,
Prantika
Thanks for your reply. Can you please show me where this option is? show relevant values under control options?
its not working how I expected. all 3 control comes from same dataset and meant for different filter values. Since control C is text field, if I enter anything, the relevant values should show in other controls instead of showing all (by default its showing all).
In this case, if I search Country and click on the drop down list, it shows All by default, when you click on the Region, it shows region related to the country. In your case, do you mean that you want to to display the region instead of All?
what is the expected behavior if it has multiple region?
Yes, if you type Argentina in Country, in the Region it should show AMER. There are no multiple values. Its always one.
Its like this (In reverse order), Country and State (free text), If I type New York in state control, in the Country control it should show USA.
any update on my request?
Hello @SantoshB, this is one of the limitations with the cascading filters. The functionality works really well when drilling down into hierarchical fields, but not great in both directions.
If your controls are Region, Country, and City, you could set it up to where you select AMER in region, then the country options display accordingly. The problem occurs if you have AMER selected, then choose USA in Country, and then change AMER to APJ. Now you will receive an error because it can’t find data for USA in APJ.
You will need to select one direction to manage the cascading filters. Either from lowest hierarchy and up, or from highest hierarchy and down, but it won’t work both ways.
I will mark this as a limitation with QuickSight and archive the topic for our support team. I hope this clears up some of the issues you are facing with the control functionalities. Thank you!
