topic Hide and show objects in one sheet(Buttons) in QlikView

Hide and show objects in one sheet(Buttons)

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

Hi Experts

I have a sheet with different buttons, I would like button_1 to show/activate CT01 (container) and button_2 to hide CT01 (container) and show/activate CT02 (Chart). All of these action must happen in one sheet, Please assist

Kind Regards,

Re: Hide and show objects in one sheet(Buttons)

jharke — Fri, 07 Oct 2016 13:17:29 GMT

Goodafternoon Teke

For the first button you add an Action like this:

Mention the Object ID (find in the relevant table / properties / general):

For the second Button:

add an Action: Minimize Object

add an Action: Restore Object:

(You could add in the first button also an action to close (minimize) the second table again.)

Re: Hide and show objects in one sheet(Buttons)

jharke — Fri, 07 Oct 2016 13:21:00 GMT

By the way: the best way to get answers on questions, is to ask your question in 'New to Qlikview' (or 'new to QlikSense')

Re: Hide and show objects in one sheet(Buttons)

parevrac — Fri, 07 Oct 2016 13:50:04 GMT

Teke,

I use variables for this --

1, create a new variable (e.g. vShow) in Settings, Variable Overview but don't give it a value

2. in add actions for the buttons use the External; Set Variable option to set values of the variable you have just created

3. in the table and chart properties; Layout tab select conditional show and enter a conditional statement like "vShow = 1" so that the table and chart would only then be visible when the variable is set to the appropriate value

I prefer this method as it hides the object totally until the user wants to see it

Re: Hide and show objects in one sheet(Buttons)

oknotsen — Mon, 10 Oct 2016 06:58:35 GMT

Topic has been moved there now.

Re: Hide and show objects in one sheet(Buttons)

Anil_Babu_Samineni — Mon, 10 Oct 2016 09:52:43 GMT

This scenario might you require to use vshow and vhide

QlikView App: Show and Hide Windows Dynamically

Re: Hide and show objects in one sheet(Buttons)

varshavig12 — Mon, 10 Oct 2016 10:32:25 GMT

You can also have a container CT03, n put CT01 and CT02 in it.

Re: Hide and show objects in one sheet(Buttons)

beck_bakytbek — Mon, 10 Oct 2016 11:18:12 GMT

Hi Teke,

watch this link: QlikView Conditionally showing and hiding the filters / objects - YouTube

i hope that helps to resolve your issue

beck