topic Re: Switch sheets with selection from search object in QlikView

Switch sheets with selection from search object

mwscott1 — Wed, 18 Mar 2015 15:47:43 GMT

I have two sheets Search and KB. The tabs are hidden. The search sheet just has a search object. I would like to automatically switch to the KB sheet once a user makes a selection from the search object. I would also need a button to take the user back to the search sheet. Thanks in advance for the help.

Re: Switch sheets with selection from search object

prieper — Wed, 18 Mar 2015 16:12:21 GMT

Suggest to create a variable: vShowHide with value 1

Layout-condition for the Search-Tab will be =$(vShowHide), for the KB-tab = NOT($(vShowHide))

Create a Trigger on update the Search-field to set the variable vShowHide to be =NOT($(vShowHide)).

This will hide the Search-Tab and make the KB-tab visible.

on the KB-tab you create a button with the same trigger.

HTH Peter

Re: Switch sheets with selection from search object

awhitfield — Wed, 18 Mar 2015 16:14:18 GMT

Hi Melvin,

I have attached a simple example QVW

andy

Re: Switch sheets with selection from search object

rubenmarin — Wed, 18 Mar 2015 16:14:43 GMT

I almost didn't answered because I didn't like this solution, but I post and you decide if you want to apply.

In document properties-->triggers you can set a trigger 'On any selection', add an action Design-->Activate Sheet and in the text box set =If(GetActiveSheetId()='Document\SEARCH', 'KB', 'SEARCH')

Then if you are in the SEARCH sheet and make any selection (no matter if it's in search object) it will go to KB sheet.

I didn't like because it will check this with every selection in the whole document