Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
1. How can i unlink sheets which have been created in a single APP.
Ex:-> i have app name call DEMO, and in that app i have 2 sheets New_Sheet1 and New Sheet2.
2. How can i unlink chart and filter in a single sheet.
EX:-> i have a sheet call DEMO sheet and in that sheet there are two filters call DECADES and YEARS and a bar chart.
How can i unlink any filter from chart.
Regards,
Ankit Jain
Hi Ankit,
I don't quite understand, what exactly do you want to un-link? One sheet from the other or the filters from a chart on the same sheet?
In the first case, just hide the tabs on top of the sheets, add some buttons to switch between sheets instead and add the action "clear selections" to them both.
In the latter case, you have to use a set_expression with the parameter 1 in your chart - that disregards all user_selections.
HTH
Hi DataNibber,
yes there are two use cases.
1. i want to unlink One sheet from the other
2. and the filters from a chart on the same sheet.
Regards,
Ankit Jain
Hi,
Well, I gave you some hints on how to solve both cases already. Let me know if you're still having trouble.
Best regards,
DataNibbler