topic HOW TO ACTIVATE NEXT SHEET ? in QlikView https://community.qlik.com/t5/QlikView/HOW-TO-ACTIVATE-NEXT-SHEET/m-p/158411#M33493 <HTML><HEAD></HEAD><BODY><P>I have a PRODUCT_TYPE, table, which has, for example, CHOCOLATE &amp; STRAWBERRY. how do i modify it such that, when i click STRAWBERRY, it automatically changes to the next sheet ? must i use triggers?</P></BODY></HTML> Mon, 14 Mar 2011 04:19:04 GMT 2011-03-14T04:19:04Z HOW TO ACTIVATE NEXT SHEET ? https://community.qlik.com/t5/QlikView/HOW-TO-ACTIVATE-NEXT-SHEET/m-p/158411#M33493 <HTML><HEAD></HEAD><BODY><P>I have a PRODUCT_TYPE, table, which has, for example, CHOCOLATE &amp; STRAWBERRY. how do i modify it such that, when i click STRAWBERRY, it automatically changes to the next sheet ? must i use triggers?</P></BODY></HTML> Mon, 14 Mar 2011 04:19:04 GMT https://community.qlik.com/t5/QlikView/HOW-TO-ACTIVATE-NEXT-SHEET/m-p/158411#M33493 2011-03-14T04:19:04Z HOW TO ACTIVATE NEXT SHEET ? https://community.qlik.com/t5/QlikView/HOW-TO-ACTIVATE-NEXT-SHEET/m-p/158412#M33494 <HTML><HEAD></HEAD><BODY><P>hi Nileshrocks yes, we can get ur requirement in two ways. one is by using triggers and another by macros. but macros kills efficiency of our application. i have a solution for ur`s.</P><P>Goto</P><P>Settings-&gt; Document Properties -&gt; Triggers -&gt; Field Event Triggers -&gt;</P><P>select the STRAWBERRY field and click "on select Edit Actions.." button</P><P>click on ADD button and select Action Type as "LayOut" and select Action as "Activate Sheet" and then click on "OK" button.</P><P>Now write the below condicion in the "Sheet ID" Text Box</P><P><STRONG>=if(getSelectedCount(STRAWBERRY ) &gt;0,SH02,)</STRONG></P><P><STRONG>i think it will work, otherwise use the below one..</STRONG></P><P><STRONG>SH02</STRONG></P><P>Regards</P><P>A'run'</P></BODY></HTML> Mon, 14 Mar 2011 04:51:39 GMT https://community.qlik.com/t5/QlikView/HOW-TO-ACTIVATE-NEXT-SHEET/m-p/158412#M33494 2011-03-14T04:51:39Z