topic Re: Forced filter in QlikView https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824984#M290589 <HTML><HEAD></HEAD><BODY><P>Click "Unlock" first, than clear selections.&nbsp; This field is locked.</P></BODY></HTML> Tue, 31 Mar 2015 12:30:55 GMT Anonymous 2015-03-31T12:30:55Z Forced filter https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824980#M290585 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I would like to edit an application made by a colleague who left my company.</P><P></P><P>In this application, there are several selection lists and for one of them, the value of the field cannot be changed.</P><P>In the active selections box, there is this filter but even if I click on "remove", or "clean", the filter doesn't disappear.</P><P></P><P>How can I remove that "forced" filter ?<IMG alt="qv.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/82474_qv.png" style="height: auto;" /></P><P></P><P></P><P>Thank you for your help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 31 Mar 2015 12:27:22 GMT https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824980#M290585 2015-03-31T12:27:22Z Re: Forced filter https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824981#M290586 <HTML><HEAD></HEAD><BODY><P>Hi Laura,</P><P></P><P>are there multiple values available for that field?</P><P>Try adding a listbox of that field to your app. It might have been locked. In that case there'll be an "unlock" option in the context menu.</P><P>HTH</P></BODY></HTML> Tue, 31 Mar 2015 12:30:13 GMT https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824981#M290586 datanibbler 2015-03-31T12:30:13Z Re: Forced filter https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824982#M290587 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Select that list box and click on unlock as shown below.</P><P></P><P><IMG alt="" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/82476_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 31 Mar 2015 12:30:16 GMT https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824982#M290587 ashfaq_haseeb 2015-03-31T12:30:16Z Re: Forced filter https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824983#M290588 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try unlock all</P><P>and then clear all</P><P></P><P>Regards</P></BODY></HTML> Tue, 31 Mar 2015 12:30:41 GMT https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824983#M290588 PrashantSangle 2015-03-31T12:30:41Z Re: Forced filter https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824984#M290589 <HTML><HEAD></HEAD><BODY><P>Click "Unlock" first, than clear selections.&nbsp; This field is locked.</P></BODY></HTML> Tue, 31 Mar 2015 12:30:55 GMT https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824984#M290589 Anonymous 2015-03-31T12:30:55Z Re: Forced filter https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824985#M290590 <HTML><HEAD></HEAD><BODY><P>You might want to check if there are any triggers that are forcing that as your selection. Also I would Reset the clear state so that it is not defaulting to that specific selection (Image below will help you reset clear state)</P><P></P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/82490_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>HTH</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Tue, 31 Mar 2015 12:33:22 GMT https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824985#M290590 sunny_talwar 2015-03-31T12:33:22Z Re: Forced filter https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824986#M290591 <HTML><HEAD></HEAD><BODY><P>Hey Guys,</P><P></P><P>Ok, I have clicked on "unlock", then I saved the document and closed it. But when I open it again, the field is locked again..&nbsp; </P><P></P><P>How can I do to save the document with no locked field ?</P><P></P><P>Thank you</P></BODY></HTML> Tue, 31 Mar 2015 13:45:20 GMT https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824986#M290591 2015-03-31T13:45:20Z Re: Forced filter https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824987#M290592 <HTML><HEAD></HEAD><BODY><P>Apparently you have an OnOpen trigger that makes selection in this field and locks it.&nbsp; You have to remove this trigger.</P></BODY></HTML> Tue, 31 Mar 2015 13:50:52 GMT https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824987#M290592 Anonymous 2015-03-31T13:50:52Z Re: Forced filter https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824988#M290593 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />You have a trigger that locks the field when you open the application.&nbsp; </P><P></P><P>Settings - Document Properties</P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/82514_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Tue, 31 Mar 2015 13:52:29 GMT https://community.qlik.com/t5/QlikView/Forced-filter/m-p/824988#M290593 2015-03-31T13:52:29Z