How make a sheet always follow a filter?

[#1]

Hello everyone!

I'm pretty new at Qlikview and I'm already developing a solution.

I have a Service Catalog Database that has a lot of dimensions, one of these are 'Nature', which are populated with 'Requests' and 'Incidents'.

OK.

What I need?

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'.

How can I do that on the sheet without the necessity to always switch (or click in) any filter?

Thanks a lot for your support!

[datanibbler]

Hi Leandro,

try using a document_level_trigger (in the document_properties, accessible via the menu or by pressing Ctrl+Alt+D)

=> 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.

HTH

Best regards,

DataNibbler

[jpenuliar]

How about using triggered bookmarks?

[Anonymous]

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 & Incidents.

To show clearly whether you have selected Requests or Incidents you could in Text Box use :

     =GetFieldSelections(Nature)

[oscar_ortiz · Accepted solution]

Another option would be to apply Set analysis to all of your expressions in your charts.

On one sheet you can add the Set Analysis portion to your expressions like this:

Sum( {< Nature={'Requests'} >} Sales)

On the other sheet you can add the Set Analysis portion to your expressions like this:

Sum( {< Nature={'Incedents'} >} Sales)

Good luck

Oscar

[#6]

OMG!

Thank you so much Oscar Ortiz!

It fitted perfectly!