topic Re: How to prevent current selection to next sheets in QlikView https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367290#M834485 <HTML><HEAD></HEAD><BODY><P>but then it is cleared and your selection for sheet 1 to 4 is lost...</P></BODY></HTML> Wed, 31 May 2017 15:03:17 GMT Anonymous 2017-05-31T15:03:17Z How to prevent current selection to next sheets https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367284#M834479 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have One QVW Report where i have 5 sheets with different views.</P><P></P><P>but if i select any filter in any first 4 Sheets it should apply to first four sheets only but not to fifth sheet.</P><P></P><P>how can i do it , can some one help me here.</P><P></P><P>Best Regards,</P><P>HK</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367284#M834479 dunnalahk123 2020-11-25T16:16:04Z Re: How to prevent current selection to next sheets https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367285#M834480 <HTML><HEAD></HEAD><BODY><P>use alternate states...</P></BODY></HTML> Wed, 31 May 2017 14:51:41 GMT https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367285#M834480 Anonymous 2017-05-31T14:51:41Z Re: How to prevent current selection to next sheets https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367286#M834481 <HTML><HEAD></HEAD><BODY><P>Hi Robin,</P><P></P><P>Thank you For your Quick Response.</P><P></P><P>Can just Explain how to use it as i did't used till now.</P><P></P><P>Best Regards,</P><P>Hk</P></BODY></HTML> Wed, 31 May 2017 14:54:41 GMT https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367286#M834481 dunnalahk123 2017-05-31T14:54:41Z Re: How to prevent current selection to next sheets https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367287#M834482 <HTML><HEAD></HEAD><BODY><P><A href="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Alternate%20States.htm" title="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Alternate%20States.htm">Alternate States ‒ QlikView</A></P><P></P><P>So you have to create 1 Alternate State(Document properties-&gt; General -&gt; Alternate State) for the fifth sheet and assign it to all objects of your fifth sheet.</P></BODY></HTML> Wed, 31 May 2017 14:55:05 GMT https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367287#M834482 micheledenardi 2017-05-31T14:55:05Z Re: How to prevent current selection to next sheets https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367288#M834483 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Go to Settings&gt;Sheet Properties&gt;Triggers&gt;Sheet Event Triggers&gt;Add Action&gt;Add&gt;Selection&gt;Under Action - Clear All&gt; Ok&gt;Ok&gt;Ok</P><P></P><P>Now if you make selection on First sheet it will applies till 4th sheet. Once you come to 5th tab it will clear that selection.</P><P></P><P></P><P>Hope it helps!!</P></BODY></HTML> Wed, 31 May 2017 15:00:33 GMT https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367288#M834483 Anonymous 2017-05-31T15:00:33Z Re: How to prevent current selection to next sheets https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367289#M834484 <HTML><HEAD></HEAD><BODY><P>For sheet 1 to 4 change nothing.</P><P>For sheet 5 add an alternate state</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/165387_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>and then on sheet 5 set in the sheet propertys your new alternate state and make sure that all charts, listboxes etc inherit the state from the sheet...</P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/165388_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 31 May 2017 15:01:31 GMT https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367289#M834484 Anonymous 2017-05-31T15:01:31Z Re: How to prevent current selection to next sheets https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367290#M834485 <HTML><HEAD></HEAD><BODY><P>but then it is cleared and your selection for sheet 1 to 4 is lost...</P></BODY></HTML> Wed, 31 May 2017 15:03:17 GMT https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367290#M834485 Anonymous 2017-05-31T15:03:17Z Re: How to prevent current selection to next sheets https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367291#M834486 <HTML><HEAD></HEAD><BODY><P>I agree <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> ...</P><P></P><P>but be careful when using alternate states there's a difference between:</P><P></P><P>sum {&lt; A= &gt;} B)</P><P>and</P><P>sum {$&lt; A= &gt;} B)</P></BODY></HTML> Wed, 31 May 2017 15:05:11 GMT https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367291#M834486 Anonymous 2017-05-31T15:05:11Z Re: How to prevent current selection to next sheets https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367292#M834487 <HTML><HEAD></HEAD><BODY><P>Yes, then we have to go for Alternate State</P></BODY></HTML> Wed, 31 May 2017 15:09:20 GMT https://community.qlik.com/t5/QlikView/How-to-prevent-current-selection-to-next-sheets/m-p/1367292#M834487 Anonymous 2017-05-31T15:09:20Z