topic Re: always one selected problem in QlikView

always one selected problem

Wed, 21 Aug 2013 17:20:14 GMT

I have a qlikview document that has multiple sheets.

Each sheet has it own set of listboxes.

The listboxes are similar on each sheet.

I want one listbox on each sheet to have a default selection.

My problem appears to be if I use the always one selected option on a listbox selection then I'm not able to click on the next sheet and change my listbox options because I'm locked in on the other sheet.

Is there a different approach that I can take to get the default set up on each sheet?

Re: always one selected problem

tresB — Wed, 21 Aug 2013 17:25:45 GMT

Try Alternate State

Re: always one selected problem

Oleg_Troyansky — Thu, 22 Aug 2013 05:42:19 GMT

You could use Triggers and Actions to force certain selections every time the Sheet is being opened. Open Sheet Properties, tab Triggers and you will see the available triggers.

THe only word of caution - the Trigger "OnActivateSheet" gets fired only when the Sheet is selected manually from the tabrow. If you have any buttons that replace standard tabs, the trigger "OnActivateSheet" won't work.