topic How to Permanently Lock a Field? in QlikView https://community.qlik.com/t5/QlikView/How-to-Permanently-Lock-a-Field/m-p/321412#M583320 <HTML><HEAD></HEAD><BODY><P>Greetings!</P><P></P><P>I'm having trouble with a calculated field.</P><P></P><P>It must be locked all the time to display accurate information on the application, but when we hit CLEAR, it clears the locked selection</P><P></P><P>The funny fact is that I have another field that does not get cleared on the same situation.</P><P></P><P>The difference between these fields:</P><P></P><P>I - the one that gets cleared is a calculated field, in a nested IF statement;</P><P>II - the one that does not get cleared have its calculation on the WHERE part of the LOAD statement.</P><P></P><P>Does anyone have a clue how to fix it?</P><P></P><P>Thank you in advance guys!!!</P></BODY></HTML> Fri, 07 Oct 2011 15:47:38 GMT 2011-10-07T15:47:38Z How to Permanently Lock a Field? https://community.qlik.com/t5/QlikView/How-to-Permanently-Lock-a-Field/m-p/321412#M583320 <HTML><HEAD></HEAD><BODY><P>Greetings!</P><P></P><P>I'm having trouble with a calculated field.</P><P></P><P>It must be locked all the time to display accurate information on the application, but when we hit CLEAR, it clears the locked selection</P><P></P><P>The funny fact is that I have another field that does not get cleared on the same situation.</P><P></P><P>The difference between these fields:</P><P></P><P>I - the one that gets cleared is a calculated field, in a nested IF statement;</P><P>II - the one that does not get cleared have its calculation on the WHERE part of the LOAD statement.</P><P></P><P>Does anyone have a clue how to fix it?</P><P></P><P>Thank you in advance guys!!!</P></BODY></HTML> Fri, 07 Oct 2011 15:47:38 GMT https://community.qlik.com/t5/QlikView/How-to-Permanently-Lock-a-Field/m-p/321412#M583320 2011-10-07T15:47:38Z How to Permanently Lock a Field? https://community.qlik.com/t5/QlikView/How-to-Permanently-Lock-a-Field/m-p/321413#M583321 <HTML><HEAD></HEAD><BODY><P>Sounds like you have a Clear State set. Use the menu option "Reset Clear State" to remove it and have Clear return to default behavior.</P><P></P><P>-Rob</P><P><A class="jive-link-external-small" href="http://robwunderlich.com">http://robwunderlich.com</A></P></BODY></HTML> Fri, 07 Oct 2011 16:30:31 GMT https://community.qlik.com/t5/QlikView/How-to-Permanently-Lock-a-Field/m-p/321413#M583321 rwunderlich 2011-10-07T16:30:31Z How to Permanently Lock a Field? https://community.qlik.com/t5/QlikView/How-to-Permanently-Lock-a-Field/m-p/321414#M583322 <HTML><HEAD></HEAD><BODY><P>Worked perfectly, thank you!</P></BODY></HTML> Mon, 10 Oct 2011 16:39:01 GMT https://community.qlik.com/t5/QlikView/How-to-Permanently-Lock-a-Field/m-p/321414#M583322 2011-10-10T16:39:01Z