topic Re: How make a sheet always follow a filter? in QlikView https://community.qlik.com/t5/QlikView/How-make-a-sheet-always-follow-a-filter/m-p/798903#M1045161 <HTML><HEAD></HEAD><BODY><P>Another option would be to apply Set analysis to all of your expressions in your charts.</P><P></P><P>On one sheet you can add the Set Analysis portion to your expressions like this:</P><P>Sum( {&lt; Nature={'Requests'} &gt;} Sales)</P><P></P><P>On the other sheet you can add the Set Analysis portion to your expressions like this:</P><P>Sum( {&lt; Nature={'Incedents'} &gt;} Sales)</P><P></P><P>Good luck</P><P>Oscar</P></BODY></HTML> Fri, 21 Nov 2014 16:32:36 GMT oscar_ortiz 2014-11-21T16:32:36Z How make a sheet always follow a filter? https://community.qlik.com/t5/QlikView/How-make-a-sheet-always-follow-a-filter/m-p/798899#M1045156 <HTML><HEAD></HEAD><BODY><P>Hello everyone!</P><P></P><P></P><P>I'm pretty new at Qlikview and I'm already developing a solution.</P><P></P><P></P><P>I have a Service Catalog Database that has a lot of dimensions, one of these are 'Nature', which are populated with 'Requests' and 'Incidents'.</P><P></P><P></P><P>OK.</P><P></P><P></P><P>What I need?</P><P></P><P></P><P>I need two sheets (with the same chart structure), one of these will always apply a filter for 'Requests', and the other one will always apply a filter for 'Incidents'.</P><P></P><P></P><P>How can I do that on the sheet without the necessity to always switch (or click in) any filter? </P><P></P><P></P><P>Thanks a lot for your support!</P></BODY></HTML> Fri, 21 Nov 2014 15:36:53 GMT https://community.qlik.com/t5/QlikView/How-make-a-sheet-always-follow-a-filter/m-p/798899#M1045156 2014-11-21T15:36:53Z Re: How make a sheet always follow a filter? https://community.qlik.com/t5/QlikView/How-make-a-sheet-always-follow-a-filter/m-p/798900#M1045157 <HTML><HEAD></HEAD><BODY><P>Hi Leandro,</P><P></P><P>try using a document_level_trigger (in the document_properties, accessible via the menu or by pressing Ctrl+Alt+D)</P><P>=&gt; There you can define all sorts of triggers. Not all work reliably, specifically when users access your apps in the browser - test that first - but there is the way to do it, in general.</P><P>HTH</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Fri, 21 Nov 2014 15:42:54 GMT https://community.qlik.com/t5/QlikView/How-make-a-sheet-always-follow-a-filter/m-p/798900#M1045157 datanibbler 2014-11-21T15:42:54Z Re: How make a sheet always follow a filter? https://community.qlik.com/t5/QlikView/How-make-a-sheet-always-follow-a-filter/m-p/798901#M1045159 <HTML><HEAD></HEAD><BODY><P>How about using triggered bookmarks?</P></BODY></HTML> Fri, 21 Nov 2014 15:53:56 GMT https://community.qlik.com/t5/QlikView/How-make-a-sheet-always-follow-a-filter/m-p/798901#M1045159 jpenuliar 2014-11-21T15:53:56Z Re: How make a sheet always follow a filter? https://community.qlik.com/t5/QlikView/How-make-a-sheet-always-follow-a-filter/m-p/798902#M1045160 <HTML><HEAD></HEAD><BODY><P>If the Objects on the sheets are the same they why have 2 sheets and not one with a List Box to toggle between Requests &amp; Incidents.</P><P></P><P>To show clearly whether you have selected Requests or Incidents you could in Text Box use :</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; =GetFieldSelections(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Nature</SPAN>)</P></BODY></HTML> Fri, 21 Nov 2014 16:02:47 GMT https://community.qlik.com/t5/QlikView/How-make-a-sheet-always-follow-a-filter/m-p/798902#M1045160 Anonymous 2014-11-21T16:02:47Z Re: How make a sheet always follow a filter? https://community.qlik.com/t5/QlikView/How-make-a-sheet-always-follow-a-filter/m-p/798903#M1045161 <HTML><HEAD></HEAD><BODY><P>Another option would be to apply Set analysis to all of your expressions in your charts.</P><P></P><P>On one sheet you can add the Set Analysis portion to your expressions like this:</P><P>Sum( {&lt; Nature={'Requests'} &gt;} Sales)</P><P></P><P>On the other sheet you can add the Set Analysis portion to your expressions like this:</P><P>Sum( {&lt; Nature={'Incedents'} &gt;} Sales)</P><P></P><P>Good luck</P><P>Oscar</P></BODY></HTML> Fri, 21 Nov 2014 16:32:36 GMT https://community.qlik.com/t5/QlikView/How-make-a-sheet-always-follow-a-filter/m-p/798903#M1045161 oscar_ortiz 2014-11-21T16:32:36Z Re: How make a sheet always follow a filter? https://community.qlik.com/t5/QlikView/How-make-a-sheet-always-follow-a-filter/m-p/798904#M1045162 <HTML><HEAD></HEAD><BODY><P>OMG!</P><P></P><P><BR />Thank you so much <A href="https://community.qlik.com/qlik-users/2149">Oscar Ortiz</A>!</P><P></P><P>It fitted perfectly!</P></BODY></HTML> Fri, 21 Nov 2014 16:35:35 GMT https://community.qlik.com/t5/QlikView/How-make-a-sheet-always-follow-a-filter/m-p/798904#M1045162 2014-11-21T16:35:35Z