topic Locking Selection on One Sheet in QlikView https://community.qlik.com/t5/QlikView/Locking-Selection-on-One-Sheet/m-p/270939#M1203097 <HTML><HEAD></HEAD><BODY><P>I have written a macro so that when you go to one sheet within the application, a selection is automatically applied and upon leaving the sheet, the selection is removed. I'm wondering if there is a way to lock that selection while on the sheet so that the user cannot inadvertantly "clear all selections" and remove it? There are a lot of items on the page so I'd prefer to not have to apply set analysis to all of it, but realize that might be the only option.</P><P>Thanks in advance for any assistance!</P></BODY></HTML> Wed, 11 Aug 2010 17:25:21 GMT 2010-08-11T17:25:21Z Locking Selection on One Sheet https://community.qlik.com/t5/QlikView/Locking-Selection-on-One-Sheet/m-p/270939#M1203097 <HTML><HEAD></HEAD><BODY><P>I have written a macro so that when you go to one sheet within the application, a selection is automatically applied and upon leaving the sheet, the selection is removed. I'm wondering if there is a way to lock that selection while on the sheet so that the user cannot inadvertantly "clear all selections" and remove it? There are a lot of items on the page so I'd prefer to not have to apply set analysis to all of it, but realize that might be the only option.</P><P>Thanks in advance for any assistance!</P></BODY></HTML> Wed, 11 Aug 2010 17:25:21 GMT https://community.qlik.com/t5/QlikView/Locking-Selection-on-One-Sheet/m-p/270939#M1203097 2010-08-11T17:25:21Z Locking Selection on One Sheet https://community.qlik.com/t5/QlikView/Locking-Selection-on-One-Sheet/m-p/270940#M1203098 <HTML><HEAD></HEAD><BODY><P>In your macro, after you make the selection, add this line:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">ActiveDocument.Fields("FIELD").Lock<BR /></PRE></BLOCKQUOTE>That will lock in whatever you have selected on that field. <BR /><BR /> <P>I think Set Analysis probably the better way to do, but it's obviously not the only way.</P></BODY></HTML> Wed, 11 Aug 2010 20:44:11 GMT https://community.qlik.com/t5/QlikView/Locking-Selection-on-One-Sheet/m-p/270940#M1203098 2010-08-11T20:44:11Z