topic Re: Selections should not effect on second sheet in QlikView

Selections should not effect on second sheet

Tue, 19 Mar 2013 13:49:14 GMT

Hi all,

I have created two sheets, In which second sheet contains tables to show only information without any filters. I dont want second sheet to get affected by the first sheet selections.

I want first sheet selections to be same when I switch from second sheet to first sheet or vice-versa

PS: I used Clear selections trigger but it didn't worked. All the listboxes in 1st sheet are checked with 'ALways one selcted value' option

Any help would be appreciated

Thanks in advance

Regards,

priya

Re: Selections should not effect on second sheet

Gysbert_Wassenaar — Tue, 19 Mar 2013 13:57:34 GMT

If you use QV11 then you can define alternate states on the General tab of the document properties window. You can then assign the different alternate states to each of your sheets on the General tab of the sheet properties window. Selections on one sheet then won't influence selections on the other sheer.

Re: Selections should not effect on second sheet

alexandros17 — Tue, 19 Mar 2013 13:58:53 GMT

Use trigger with bookmarks ...

Re: Selections should not effect on second sheet

Tue, 19 Mar 2013 13:59:27 GMT

Thanks for quick reply.

Actually I know that but unfortunately I am working on QV10 . Any solution for this?

Re: Selections should not effect on second sheet

Gysbert_Wassenaar — Tue, 19 Mar 2013 14:06:10 GMT

Create a bookmark per sheet. Then set the bookmark with an action on the OnLeaveSheet trigger to save the current selections and reapply the bookmark with the OnActivateSheet trigger to retrieve the selections previously active on the sheet. You'll need to do this for each sheet. There's no other way that I know of that works with QV10.

Re: Selections should not effect on second sheet

Tue, 19 Mar 2013 14:06:38 GMT

Thanks for reply

But my selections are not stable to use a bookmark trigger

Re: Selections should not effect on second sheet

Wed, 20 Mar 2013 12:34:43 GMT

Thanks for your reply Gysbert.

On my sheet1, on leave page action i applied create bookmark and on acctivate page I applied bookmark. On the sheet 2 , on activate page I applied clear all selections trigger .

Here whenever i switch form sheet 2 to sheet 1 It shows my first time bookmarked selections. If I change the selections when I am switching back it shows the first time bookmarked selections.

Can you please help me