Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
enzazaden
New Contributor III

Remember user selection bij switching sheets

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

1 Solution

Accepted Solutions
Highlighted
enzazaden
New Contributor III

Re: Remember user selection bij switching sheets

1 Reply
Highlighted
enzazaden
New Contributor III

Re: Remember user selection bij switching sheets