There are Workarounds to achieve that, but not something Direct at this moment:
Have a look Here Pl
I will check on the links.
The Apply button on the Region QF will still refresh the viz the moment we click on it.
What I am looking for is, changing the values in Region, Country, State should only update the cascading QF but not the viz. The viz should also refresh when there is a global Apply button.
1 of 1 people found this helpful
Yes Sure, there are few Other Workarounds too, but at This moment..It is What it is.
As per your question i am doing all the things. follow some steps for it are as following.
step 1. create All cascading filters.
step 2. (a) For Region->All values In the Database
(b) For Country->Only Relevant Values
(c) For State->select Context Filter->Only context Values.
(d) For City->Only Relevant Values.
step 3.Go to Worksheet->Auto Updates->Disable Auto Update worksheet.
step then run sheet and validate data as per your requirement.
please check the solution and reply if it is useful or not. i have attached screen shot also. please check it.
Please can you explain your question one more time in detail so i understand your exact requirement.
Please do reply.