Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
Valued Contributor III

Re: QlikView document with multiple sheets

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
Contributor III

Re: QlikView document with multiple sheets

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

Not applicable

Re: QlikView document with multiple sheets

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

Re: QlikView document with multiple sheets

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
Valued Contributor III

Re: QlikView document with multiple sheets

Ram,

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

Not applicable

Re: QlikView document with multiple sheets

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

Re: QlikView document with multiple sheets

me?Smiley Happy

azimabadi
Contributor II

Re: QlikView document with multiple sheets

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

Re: QlikView document with multiple sheets

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

Community Browser