topic Re: QlikView document with multiple sheets in QlikView

QlikView document with multiple sheets

Thu, 19 Jul 2012 09:32:23 GMT

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.

Re: QlikView document with multiple sheets

jagannalla — Thu, 19 Jul 2012 09:39:46 GMT

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

Re: QlikView document with multiple sheets

advait_thakur — Thu, 19 Jul 2012 09:39:46 GMT

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

Re: QlikView document with multiple sheets

Thu, 19 Jul 2012 10:09:56 GMT

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

Re: QlikView document with multiple sheets

Thu, 19 Jul 2012 10:21:49 GMT

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

Re: QlikView document with multiple sheets

jagannalla — Thu, 19 Jul 2012 10:31:04 GMT

Ram,

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

Re: QlikView document with multiple sheets

Thu, 19 Jul 2012 10:43:31 GMT

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

Re: QlikView document with multiple sheets

Thu, 19 Jul 2012 11:44:35 GMT

me?:)

Re: QlikView document with multiple sheets

azimabadi — Thu, 19 Jul 2012 12:08:19 GMT

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

rwunderlich — Thu, 19 Jul 2012 14:46:21 GMT

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