I use relevant controls to filter the options of a downstream control based on the value of an upstream control. If I select values for both my upstream and downstream controls and then change my upstream control, my downstream control would keep its value, which could be invalid. How do I automatically reset the value of my downstream control whenever I change the value of my upstream control?
Hi,
Can you please check whether QuickSight cascaded filter control helps to meet your requirement.
Example is given in QuickSight Author workshop interactivity exercise-2
Thanks for responding.
I am actually using cascaded filter control, which is already useful. However the problem that I described in my original message even affects cascaded filter control. Updating a “top” filter control does not reset a “bottom” filter control.
I’ve attached screenshots to show this more clearly.
The valid values for Index when selecting Region: EU
and Marketplace: 3
are eu-*-uk
.
The valid values for Index
when selecting Region: EU
and Marketplace: 4
are eu-*-de
.
However if I first select Region: EU
, Marketplace: 3
, and Index: eu-apparel-outlet-uk
, and then change Marketplace
to 4
, then Index
remains eu-apparel-outlet-uk
, even though that’s not a valid value.
I believe that it’s the same issue that was discussed in this topic: