topic Re: sheets in QlikView

sheets

prabhas277 — Wed, 05 Aug 2015 06:54:13 GMT

Hi experts,

How to hide the sheets using buttons?

Anonymous — Wed, 05 Aug 2015 07:00:33 GMT

you can use variables om conjuction with actions

1) for each sheet define Show Conditional: if (vShowSheet=1)

2) create button with Action External Set variable

Variable vShowSheet with Value 1 or 0 (dependng if you want to Show sheet = 1 or hide sheet = 0)

you Need a variable for every sheet or sheet Group you want to Show/hide

maxgro — Wed, 05 Aug 2015 07:20:50 GMT

see attachment, button sheet2 and sheet3 and back to sheet1

vardhancse — Wed, 05 Aug 2015 07:59:12 GMT

using layout conditions with variables we can achieve the same.

more over if we can hide the sheets by default will make the look and feel much better.

Settings->Document Properties->General<tab>->Hide tab row(Check box)