topic Activating a sheet/Hiding with a button in QlikView https://community.qlik.com/t5/QlikView/Activating-a-sheet-Hiding-with-a-button/m-p/1200139#M876842 <HTML><HEAD></HEAD><BODY><P>I'm trying to activate AND show a sheet while hiding the sheet that the user was just viewing. I have 5 tabs currently in my dashboard, with a button to click that will activate the sheet based on the users choice, which is fine, but the user can view all of the tabs at the top as well. I would like to only have ONE tab visible at ANY given time, and upon (ONE)click of&nbsp; any buttons the user can view a new sheet with the old one being hidden.</P><P></P><P>Currently:</P><P>I have activate sheet</P><P>I also have Conditional Hides on my sheets.</P><P></P><P>The issue:<BR />1) It takes two button clicks to a) unhide the sheet then b) activate the sheet.</P><P>2) After the new sheet is active the old sheet remains visible.</P><P></P><P>I would like 1) to reduce to 1 one click and 2) to make the prior sheet invisible, regardless of where it lays within the tabs.</P><P><BR />Is there a way to do this easily in qlikview? I think it can be done with a lot of nesting and IF conditions, but that can become complicated if more tabs are added...</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT lucasdavis500 2020-11-25T16:16:04Z Activating a sheet/Hiding with a button https://community.qlik.com/t5/QlikView/Activating-a-sheet-Hiding-with-a-button/m-p/1200139#M876842 <HTML><HEAD></HEAD><BODY><P>I'm trying to activate AND show a sheet while hiding the sheet that the user was just viewing. I have 5 tabs currently in my dashboard, with a button to click that will activate the sheet based on the users choice, which is fine, but the user can view all of the tabs at the top as well. I would like to only have ONE tab visible at ANY given time, and upon (ONE)click of&nbsp; any buttons the user can view a new sheet with the old one being hidden.</P><P></P><P>Currently:</P><P>I have activate sheet</P><P>I also have Conditional Hides on my sheets.</P><P></P><P>The issue:<BR />1) It takes two button clicks to a) unhide the sheet then b) activate the sheet.</P><P>2) After the new sheet is active the old sheet remains visible.</P><P></P><P>I would like 1) to reduce to 1 one click and 2) to make the prior sheet invisible, regardless of where it lays within the tabs.</P><P><BR />Is there a way to do this easily in qlikview? I think it can be done with a lot of nesting and IF conditions, but that can become complicated if more tabs are added...</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Activating-a-sheet-Hiding-with-a-button/m-p/1200139#M876842 lucasdavis500 2020-11-25T16:16:04Z Re: Activating a sheet/Hiding with a button https://community.qlik.com/t5/QlikView/Activating-a-sheet-Hiding-with-a-button/m-p/1200140#M876844 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Fri, 28 Oct 2016 17:59:13 GMT https://community.qlik.com/t5/QlikView/Activating-a-sheet-Hiding-with-a-button/m-p/1200140#M876844 maxgro 2016-10-28T17:59:13Z Re: Activating a sheet/Hiding with a button https://community.qlik.com/t5/QlikView/Activating-a-sheet-Hiding-with-a-button/m-p/1200141#M876846 <HTML><HEAD></HEAD><BODY><P>This works, but I want the user to have access to multiple buttons to choose their sheet. i.e. there are 4 buttons at all times (5 sheets total) showing. Whatever button they choose is the sheet they navigate to, it shouldn't have to be in order...</P></BODY></HTML> Tue, 01 Nov 2016 13:20:01 GMT https://community.qlik.com/t5/QlikView/Activating-a-sheet-Hiding-with-a-button/m-p/1200141#M876846 lucasdavis500 2016-11-01T13:20:01Z Re: Activating a sheet/Hiding with a button https://community.qlik.com/t5/QlikView/Activating-a-sheet-Hiding-with-a-button/m-p/1200142#M876848 <HTML><HEAD></HEAD><BODY><P>PFA </P></BODY></HTML> Tue, 01 Nov 2016 13:55:01 GMT https://community.qlik.com/t5/QlikView/Activating-a-sheet-Hiding-with-a-button/m-p/1200142#M876848 maxgro 2016-11-01T13:55:01Z