topic onLeaveSheet in QlikView https://community.qlik.com/t5/QlikView/onLeaveSheet/m-p/198727#M57928 <HTML><HEAD></HEAD><BODY><P>Hi,<BR /><BR />I'm creating a sheet in which I want only a few people to access. What I have done is created a variable and set to 0.<BR />Set a calculation condition on the hidden sheet to be 1, so when you open the document the sheet isn't there.<BR />I then created a transparent button on a visible sheet to change the variable to 1 so the sheet appears and i added a trigger for onLeaveSheet -Set Variable to 0 so when I leave the sheet, the sheet should disappear but it doesn't.<BR /><BR />Can anyone tell me what I am doing wrong here?<BR /><BR />Thanks in advance,<BR />mckay9999</P></BODY></HTML> Mon, 13 Sep 2010 16:26:30 GMT 2010-09-13T16:26:30Z onLeaveSheet https://community.qlik.com/t5/QlikView/onLeaveSheet/m-p/198727#M57928 <HTML><HEAD></HEAD><BODY><P>Hi,<BR /><BR />I'm creating a sheet in which I want only a few people to access. What I have done is created a variable and set to 0.<BR />Set a calculation condition on the hidden sheet to be 1, so when you open the document the sheet isn't there.<BR />I then created a transparent button on a visible sheet to change the variable to 1 so the sheet appears and i added a trigger for onLeaveSheet -Set Variable to 0 so when I leave the sheet, the sheet should disappear but it doesn't.<BR /><BR />Can anyone tell me what I am doing wrong here?<BR /><BR />Thanks in advance,<BR />mckay9999</P></BODY></HTML> Mon, 13 Sep 2010 16:26:30 GMT https://community.qlik.com/t5/QlikView/onLeaveSheet/m-p/198727#M57928 2010-09-13T16:26:30Z onLeaveSheet https://community.qlik.com/t5/QlikView/onLeaveSheet/m-p/198728#M57929 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>don´t you need to put a "save document" somewhere?</P><P>if you are using Version 9 you could create an exit button setting the var to 0, saving the document and then closing it.</P><P>Cheers</P><P></P><P>Adriano</P></BODY></HTML> Mon, 13 Sep 2010 18:14:44 GMT https://community.qlik.com/t5/QlikView/onLeaveSheet/m-p/198728#M57929 2010-09-13T18:14:44Z