Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I built an effort-made sheet full of complex objets and now I would like to copy it and, in the copied version, change the value of only one of its filter fields without change anything in the original sheet. I was thinking in using 'Alternate States' but this solution would detach all the filters not only the one I need.
How could I made the new version be different than the original one in only one field?
Thanks.
No, there isn't. Not with alternate states. You can try using the OnLeave and OnActivate sheet triggers to respectively replace and activate a sheet specific bookmark. But then you could use bookmarks without using a copy of the sheet anyway. Or just use the Back and Forward options to move back and forward between selections.
Assign the new alternate state only to the listbox that should differ from the default state. Then in expressions in charts where selections in that field should apply add a set modifier to use the alternate state selection for that one field. For example sum(Sales) becomes sum({<MyField=AltState1::MyField>}Sales) if you want to use the selections for field MyField from alternate state AltState1.
Hi,
this solution will mean to modified every single object, I have many, is not there a way to avoid this refering the sheet name or something?
Thanks
No, there isn't. Not with alternate states. You can try using the OnLeave and OnActivate sheet triggers to respectively replace and activate a sheet specific bookmark. But then you could use bookmarks without using a copy of the sheet anyway. Or just use the Back and Forward options to move back and forward between selections.