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

QlikView document with multiple sheets

My QlikView document have multiple sheets, filter selection in one sheet get reflects to all the sheets. Is there any way to avoid that, want to restrict the filter particular to that sheet only.

9 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III

Hello,

Please run Clear All Action in ActiveSheet Trigger. SheetProperties -> Triggers -> OnActiveSheet -AddAction -Add - Choos Clear All From Action box ->Ok

If you want to do for objects, just add set analysis expression Sum({<filterColumn =>}Column)

Hope it helps you

Cheers!

Jagan

advait_thakur
Creator III
Creator III

Hi Ram,

Please keep Clear All trigger on rest of the sheet, By this your other sheets will not get reflect.

In Sheet properties, Put the trigger OnActivateSheet trigger > Add the Action > Clear All

Also you can do it on same sheet properties, in OnLeaveSheet > Clear All

Thanks,

Advait

Join the official Qlik Enthusiast's page here
https://www.linkedin.com/groups/6513382/
Not applicable
Author

Thanks for the reply.

I am using a single field which is common on all the sheets with some other fields as filter. If I use Clear All then every time user have to make the selection. Is there any other way around.

Thanks,

Ram

Not applicable
Author

like they say

but before clearing all the selections you should save tmem to the bookmark

1. save selections to bookmark

2. clear selection

then when get back to that sheet you can apply that bookmark

there is no other way

jagannalla
Partner - Specialist III
Partner - Specialist III

Ram,

Can you show with example what you are trying to achive.

Not applicable
Author

Hi Ram,

Yes Pari is correct. I too had faced in one of my project, then i implemented by using BookMarks.

Bookmark can save and retrieve the filter selections whenever we required, that's the great feature of BookMark in Qlikview.

An additional step for your requirements will be fulfilled by applying triggers only in "On-Leave" and "On-Activate" actions.i.e; Right-Click on sheet --> Properties --> Triggers --> Sheet Events

1.)On-Leave

Action Type --> Bookmarks --> ReplaceBookmark= BM01

Action Type --> Selections --> ClearAll

2.)On-Activate

Action Type --> Bookmarks --> ApplyBookmark = BM01

I hope this might helps you.

Regards,

Satish

Not applicable
Author

me?:)

azimabadi
Creator III
Creator III

Hi all,

i think in this case the best way is to use "alternate state". define an alternate state in :

Settings --> Document properties --> General : Alternate States...

then for every object that is on that special sheet, set this alternate state in:

properties --> General : Alternate State

i hope this help you.

Best regards

Peyman

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You can place each sheet in a different state and let the objects inherit the sheet state.

For field that is common across sheets, I believe you'll have to set up an action to copy the selection to all the other states.

-Rob