topic Re: Disable Sheet Selection in QlikView

Disable Sheet Selection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

How do I disable subsequent sheets (Not hide) from being selected until I have selected a value in the multibox on the main sheet.

Re: Disable Sheet Selection

passionate — Fri, 20 Apr 2018 15:12:31 GMT

how are you selecting subsequent sheet?

is it via trigger activate sheet on text object.

if yes use two text boxes and conditionally hide show your text box

Re: Disable Sheet Selection

Peter_Cammaert — Fri, 20 Apr 2018 15:16:19 GMT

You can do that by hiding the Tabrow (see Settings->Document Properties->General->Hide Tabrow) and devising some other way of navigating your sheet list. For example, add a button to each sheet and enable/disable those buttons depensing on the number of selected values in a field. Or for a cleaner layout, add Text Boxes with Actions.

AFAIK the tabrow itself, when displayed, cannot be made ReadOnly.

Re: Disable Sheet Selection

Anonymous — Fri, 20 Apr 2018 16:38:09 GMT

Selecting the sheet by clicking on the Tabrow

Re: Disable Sheet Selection

Anonymous — Fri, 20 Apr 2018 16:39:56 GMT

This maybe the best option since I can't disable certain sheets from the Tabrow from being selected via mouse click.

Re: Disable Sheet Selection

Amit — Mon, 30 Jan 2023 15:44:38 GMT

This is what I was looking for! Top answer and a good technique to use!