topic Re: Hide sheets in QlikView

Hide sheets

Anonymous — Fri, 20 Mar 2015 10:48:12 GMT

Hi guys,

How can I hide the qlikview sheets? Because I go on them only clicking a button and so I don't want to see them on the top of the project.
Thank you all

Re: Hide sheets

Gysbert_Wassenaar — Fri, 20 Mar 2015 10:52:07 GMT

On the General tab of the sheets Properties window enable the option Show Conditional and enter 0 in the input field.

Or do you mean the tab row? You can disable that by enabling the option Hide Tabrow on the General tab of the Document Properties window.

Re: Hide sheets

sagarkharpude — Fri, 20 Mar 2015 10:53:17 GMT

Goto sheet properties->General Tab-> Select Conditional-> Write '=0'

Re: Hide sheets

Fri, 20 Mar 2015 10:55:59 GMT

hi,

PFA,

You can create button for as sheetName in each sheet or textbox like you want ,

add action> activate sheet> pass sheet ID of other sheet & then select hide tabrow option from general of document properties.

Re: Hide sheets

Anonymous — Fri, 20 Mar 2015 10:57:30 GMT

But when I click on the button i don't see the hided tab

Re: Hide sheets

Fri, 20 Mar 2015 10:59:49 GMT

Hi,

you can try this.

Go to Doc properties -->> General Tab-->> Hide tabrow

Re: Hide sheets

hariprasadqv — Fri, 20 Mar 2015 10:59:54 GMT

Hi,

Take a variable and assign 0 to it. Use the variable in sheet properties under layout's show condition if the variable value is1; It indicates sheet is hidden when the variable values is other than 1. Use Action in Text/button object to set variable value to 1 for showing the sheet.

Re: Hide sheets

Gabriel — Fri, 20 Mar 2015 11:06:13 GMT

Hi,

Your question have been answered.

You want to hide a sheet and only see the sheet when you click on a button. So what you need to do is

Go to Doc properties -->> General Tab-->> Hide tabrow then click on the button.

Re: Hide sheets

Anonymous — Fri, 20 Mar 2015 11:27:24 GMT

Thank you krishnama, your answer is the most complete and correct!

Re: Hide sheets

Anonymous — Mon, 23 Mar 2015 10:14:35 GMT

Thank you Gysbert