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?
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.
