Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Detatch sheets

I have two tabs on one QlikView document.  Each tab uses a separate database, with different dimensions to filter each one.  There are no similar columns for the two database tables. Right now I am using triggers to clear selections when a user jumps from one tab to the other.  This works perfectly up until the user starts clicking the back button... The current selection box will go back to show the selections that were prior to the "clear all" trigger.

Example:  User moves from Tab A to Tab B.  The activate sheet trigger from Tab B clears all selections.  User clicks on the back button.  Selections are now showing from the prior Tab A, but the user is active on Tab B.

Is there a way that I can detatch the sheets from each other, or clear the selection history so that a user cannot backtrack beyond a certain point?

10 Replies
Not applicable
Author

What version are you on?

Not applicable
Author

QlikView 11

Not applicable
Author

Alright that is good, what you can do is go to Settings, Document Properties, and find the button on the General tab marked as Alternate States.

Create an alternate state: Tab2

Hit ok until you are back on your document.

Then for every object on tab 2 go to the general properties tab  and select Tab2 from the alternate state drop down.

Doing this for every object should completely isolate this tab from selections in the other and vise versa. The only thing I believe that effects both is the clear all.

Not applicable
Author

Tried the alternate states, no luck.  Still having information from Tab A show up in the current selection box from Tab B.  Is there a way to use a trigger to change the selection state to the very first one?

Not applicable
Author

Did you change the current selections box on tab 2 to the alternate state?

I currently use this method in one of my documents where 1 tab is completly seperate from the others.

Edit:

Also yes, under the trigger properties you can select the alternate state from the actions tab

Not applicable
Author

That did the trick. However, the back button still selects items from outside the alternate state.  I notice the green circle next to Tab A whenever I start clicking the back button.  For cosmetic issues, is there a feature that I can reset the selecions back to the beginning?

Not applicable
Author

You basically want to reprogram the back button to act as a clear button? (Return to Open state) I am not aware of being able to change the function of the built in buttons.

Not applicable
Author

Do you think this can be done by creating a macro?

Not applicable
Author

It might be, I have no experience with macros so it might be better to create a new discussion with that question, it would pull the more experienced macro creators to help.