topic Re: Hide objects in QlikView

Hide objects

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

Hi,

I have 10 sheets in my application, i want to conditionally hide and show 4 sheets in this application.I want to create a buttons in these 4 sheets i will click on one button it will display that sheet and remaining 3 sheets should be hide.

it is possible in qlikview, Can anyone know the solution for this...

thanks in advance,

Re: Hide objects

sunny_talwar — Tue, 26 Jul 2016 11:40:18 GMT

Yes hiding and showing sheets based on button clicks is possible with QlikView. You can set hide/show condition on the general tab of sheet properties

Re: Hide objects

saimahasan — Tue, 26 Jul 2016 11:40:27 GMT

Yes you can do it.. Go to conditional option in Layout tab and use the variables as 1 to show and 0 to hide.

On the click of the buttons set the variable value as 1 under Actions tab and set Activate Sheet value as the SheetID of the sheet you want to activate.

Re: Hide objects

t_moutault — Tue, 26 Jul 2016 11:46:06 GMT

Hi,

try this :

first step : create variable vHideSheet1

second step : on the sheet properties, select show sheet conditionnal : vHideSheet1=1

third step : create button (on another sheet !) like this

hope this help.

Re: Hide objects

migueldelval — Tue, 26 Jul 2016 11:47:32 GMT

Hi Sonytgot,

First you need to create a variable (eg: vShow=0)

Second, make a button and in action add--external--set variable--variable: vShow -- Value: 1

Third: In each sheet put this expression: =IF(vShow=1, 1, 0)

If yopu want to make other conditional only you need to change de expression (eg:=IF(vShow=, 1, 0))

Regards

Miguel del Valle

Re: Hide objects

sonysree88 — Tue, 26 Jul 2016 12:30:36 GMT

Hi Thomas,

Its really great help to me..Thank you ..

Its working fine but its hidden,Again if want to show that object how can we get back that sheet..Please let me know ..

Re: Hide objects

sonysree88 — Tue, 26 Jul 2016 12:36:03 GMT

If i want to rollback that hidden sheet how can we do,

Can you any one please help me out with procedure.

Re: Hide objects

t_moutault — Tue, 26 Jul 2016 12:36:19 GMT

you have to go to : settings->document properties-> sheets

that's why the button needs to be in another sheet ! (clik to hide or show the sheet)

Re: Hide objects

t_moutault — Tue, 26 Jul 2016 12:42:29 GMT

clik to hide or show the sheet

Re: Hide objects

sonysree88 — Tue, 26 Jul 2016 12:44:18 GMT

Its cleared now..Thanks for your time

Re: Hide objects

saimahasan — Tue, 26 Jul 2016 13:07:08 GMT

what do you mean by rollback?? Please elaborate..

Re: Hide objects

Colin-Albert — Tue, 26 Jul 2016 13:11:09 GMT

There is a keyboard shortcut which makes all hidden objects and sheets visible.

Ctrl-Shift-S will toggle all hidden objects between being hidden and visible.

Re: Hide objects

sonysree88 — Wed, 27 Jul 2016 12:43:45 GMT

Its cleared now..Thanks

I am asking like how to show hidden objects..

Re: Hide objects

migueldelval — Wed, 27 Jul 2016 12:47:12 GMT

Hi Sonygot,

If your question was answered, please close it,

Regards

Miguel del Valle

Re: Hide objects

sonysree88 — Wed, 27 Jul 2016 12:51:39 GMT

Can you let me know how to close this