Remember user selection bij switching sheets

Anonymous — Thu, 14 Jan 2016 15:37:19 GMT

Is it possible to realize next process?

1. User selects his years in sheet 'Dashboard'

2. User goes to sheet 'Planning', where we don't use filter 'Year'.
The current selection box has to show all selections, excepts filter 'Year'.

3. When the user leaves sheet 'Planning' the selected\saved years of point 1 has to be working again.

Below one of the many options I tried to solve this. I don't know how to solve point 3 of the process.

Please let me know if there is a better solution to achieve above process.

I manage to make OnActivateSheet triggers in sheet 'Planning' to set the variable of year selections (see blue text box) and clear field 'Year' (see list box Year) for the desired presentation of the current selection box of point 2. But how do I realize point 3 with the OnLeaveSheet trigger? Is it possible to activate the year selections variable (vYearSelected) again, so the user can work further with the selections of sheet 'Dashboard' made in point 1?

Sheet properties 'Planning'

Document settings, sheet Variables

Re: Remember user selection bij switching sheets

Anonymous — Fri, 15 Jan 2016 11:04:16 GMT

Solved it with post:Copy Selections from one field to another

topic Remember user selection bij switching sheets in QlikView

Remember user selection bij switching sheets

Re: Remember user selection bij switching sheets