Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How make a sheet always follow a filter?

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!

1 Solution

Accepted Solutions
oscar_ortiz
Partner - Specialist
Partner - Specialist

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

View solution in original post

5 Replies
datanibbler
Champion
Champion

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
Partner - Specialist III
Partner - Specialist III

How about using triggered bookmarks?

Anonymous
Not applicable
Author

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
Partner - Specialist
Partner - Specialist

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

Not applicable
Author

OMG!


Thank you so much Oscar Ortiz!

It fitted perfectly!