topic Independent selections in different sheets in QlikView

Independent selections in different sheets

arixooo123 — Sun, 27 Jul 2014 03:48:26 GMT

Is it possible to have independent Selections in different sheets? if no, i read in one of posts in here that the only thing we can do is to set selection boxes automatically clear the selections after changing sheets. i don't know how to do that either..if you know i would be grateful to tell me.

thank you

Re: Independent selections in different sheets

eduardo_sommer — Sun, 27 Jul 2014 04:00:10 GMT

It is possible. You can define alternate states for each sheet, so that the selections in one sheet doesn't interfere with the selections in the other. Take a look in this post: ALTERNATE STATES

Eduardo

Re: Independent selections in different sheets

fkeuroglian — Sun, 27 Jul 2014 14:45:27 GMT

Hi, you could that clear all the selections when you acces to the sheet or when you leave the sheet

go to:

1) Right click in the sheet, property of sheet

2) go to trigger

3) go to Add a action(choose when you leave the page or acces to the page)

4)go to add

5)selection

6)delete all

this mean that when you acces or leave the page will delete all the selections

good luck

Fernando

Re: Independent selections in different sheets

Sun, 27 Jul 2014 16:40:27 GMT

Hi,

Another possible option is to create bookmarks for each sheet.

Then you set the below triggers in the sheet properties under the Triggers tab:

OnActivateSheet: Add > Bookmark > ApplyBookmark action and type the bookmark ID that you want to be related to that sheet.

OnLeaveSheet: Add > Bookmark > ReplaceBookmark action and type the same bookmark ID.

In this way you'll have independent selections with the possibility to save and load back the selections within every sheet.