Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Full Sheet copied to change only a field value

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.

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand
Not applicable
Author

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

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand