topic Re: Fixed value while Sheet Selection in QlikView https://community.qlik.com/t5/QlikView/Fixed-value-while-Sheet-Selection/m-p/754309#M268713 <HTML><HEAD></HEAD><BODY><P>Maybe you used SheetActivate-Trigger which set the value from field year to a certain value and then locked this field and by SheetDeactivate you unlocked and deselect again.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 22 Jan 2015 23:07:50 GMT marcus_sommer 2015-01-22T23:07:50Z Fixed value while Sheet Selection https://community.qlik.com/t5/QlikView/Fixed-value-while-Sheet-Selection/m-p/754307#M268711 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Is there any way where I can define value for field for particular Sheet and would stay last. Even if you clear it won't change.</P><P></P><P>Let say if I have 3 Sheets '2009', '2010' and '2011'.</P><P>I want to populate data for specific year without defining in Set analysis and not Resetable.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 22 Jan 2015 21:37:34 GMT https://community.qlik.com/t5/QlikView/Fixed-value-while-Sheet-Selection/m-p/754307#M268711 Anonymous 2015-01-22T21:37:34Z Re: Fixed value while Sheet Selection https://community.qlik.com/t5/QlikView/Fixed-value-while-Sheet-Selection/m-p/754308#M268712 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>Any example?</P></BODY></HTML> Thu, 22 Jan 2015 22:11:49 GMT https://community.qlik.com/t5/QlikView/Fixed-value-while-Sheet-Selection/m-p/754308#M268712 MarcoARaymundo 2015-01-22T22:11:49Z Re: Fixed value while Sheet Selection https://community.qlik.com/t5/QlikView/Fixed-value-while-Sheet-Selection/m-p/754309#M268713 <HTML><HEAD></HEAD><BODY><P>Maybe you used SheetActivate-Trigger which set the value from field year to a certain value and then locked this field and by SheetDeactivate you unlocked and deselect again.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 22 Jan 2015 23:07:50 GMT https://community.qlik.com/t5/QlikView/Fixed-value-while-Sheet-Selection/m-p/754309#M268713 marcus_sommer 2015-01-22T23:07:50Z Re: Fixed value while Sheet Selection https://community.qlik.com/t5/QlikView/Fixed-value-while-Sheet-Selection/m-p/754310#M268714 <HTML><HEAD></HEAD><BODY><P>Use the feature "Set Clear State"</P><P>1) Put your sheet in an Alternate State</P><P>2) Make your default selections</P><P>3) Click on "Set Clear State"</P><P><IMG alt="Capturar.PNG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/76037_Capturar.PNG" style="max-width: 620px; height: auto;" /></P></BODY></HTML> Thu, 22 Jan 2015 23:20:48 GMT https://community.qlik.com/t5/QlikView/Fixed-value-while-Sheet-Selection/m-p/754310#M268714 Clever_Anjos 2015-01-22T23:20:48Z Re: Fixed value while Sheet Selection https://community.qlik.com/t5/QlikView/Fixed-value-while-Sheet-Selection/m-p/754311#M268715 <HTML><HEAD></HEAD><BODY><P>It's right answer. Thanks Clever for your suggestion.</P><P></P><P>Thanks Marcus.</P></BODY></HTML> Fri, 23 Jan 2015 13:59:50 GMT https://community.qlik.com/t5/QlikView/Fixed-value-while-Sheet-Selection/m-p/754311#M268715 Anonymous 2015-01-23T13:59:50Z Re: Fixed value while Sheet Selection https://community.qlik.com/t5/QlikView/Fixed-value-while-Sheet-Selection/m-p/754312#M268716 <HTML><HEAD></HEAD><BODY><P>Thanks Marcus for your valuable time</P></BODY></HTML> Fri, 23 Jan 2015 14:00:17 GMT https://community.qlik.com/t5/QlikView/Fixed-value-while-Sheet-Selection/m-p/754312#M268716 Anonymous 2015-01-23T14:00:17Z