topic Re: Apply conditional show/hide on specific table by clicking object from container in QlikView

Apply conditional show/hide on specific table by clicking object from container

Tue, 09 Jun 2015 09:02:51 GMT

Hi there,

Can anyone help me out with this one?

Is it possible in QV to apply conditional @expressions to (show/hide a specific table) when a Chart Object is clicked from a Container.

See attached image sample:

If I clicked the Procurement tab in Container object, Procurement Table has to be shown and Status table should be hidden.

Thank you so much...

-Bea

Re: Apply conditional show/hide on specific table by clicking object from container

giakoum — Tue, 09 Jun 2015 09:09:22 GMT

There is no actions functionality for a container.

The only way to achieve that is to place text objects above the container labels and put the action there.

Assuming that the user does not move your objects, this is an OK solution.

Re: Apply conditional show/hide on specific table by clicking object from container

sushil353 — Tue, 09 Jun 2015 09:12:23 GMT

Hi,

Why don't you use Button and make them visible as container view..

And then you can easily hide unhide object in Chart property> Layout tab > Conditional

HTH

Sushil

Re: Apply conditional show/hide on specific table by clicking object from container

vcanale — Tue, 09 Jun 2015 09:39:30 GMT

Hi,
You can use a List box instead of the Container to select (Show/Hide) the specific Chart Object with the relative Table

Re: Apply conditional show/hide on specific table by clicking object from container

Tue, 09 Jun 2015 09:52:01 GMT

Why use a container object. U can just create buttons for text objects and use actions to achieve this.

Re: Apply conditional show/hide on specific table by clicking object from container

Tue, 09 Jun 2015 10:12:10 GMT

Okay. Considering I used a Text/Button objects on this, how am I going to apply the condition? What expressions do I need to put on my conditions? Is there a function I need to use? pls. advise. Thanks!

Re: Apply conditional show/hide on specific table by clicking object from container

giakoum — Tue, 09 Jun 2015 10:20:29 GMT

Create a variable.

Create an action on the text box to set this variable to 1

Use show/hide condition on the chart : If variable <> 1, hide

Re: Apply conditional show/hide on specific table by clicking object from container

giakoum — Tue, 09 Jun 2015 10:23:58 GMT

see attached

Re: Apply conditional show/hide on specific table by clicking object from container

antoniotiman — Tue, 09 Jun 2015 10:41:14 GMT

Hi Bea,

in This cases I use Containers in Container.

The SubContainer is Type grid.

Regards,

Antonio