topic Re: Placing buttons in container tabs, conditional visibility in QlikView

Placing buttons in container tabs, conditional visibility

Thu, 29 May 2014 17:41:31 GMT

Hello everyone,

I have a one-dimension pie chart that I have restricted to only show the first 15 Values. Every other value falls under 'Other', and clicking on Other reveals the next 15 values.

I wanted to install a Back button in the pie chart legend that would allow me to navigate back to the top 15 values. It would therefore have the same functionality of the arrow you see in the legend when you have a drill-down group as a dimension.

My problem is that the pie chart is within a container with three tabs. When I click on another tab, the Back button remains visible and gets in the way of my other charts/tables.

Does anyone know how I can set the Back button to only be visible when I am in the pie chart tab?

Thanks!

Re: Placing buttons in container tabs, conditional visibility

cfz — Thu, 29 May 2014 18:25:56 GMT

Hi Andrew,

You can try to put transparent buttons on top of the container tabs, associated to the buttons you can put an action that changes the value of a variable.Then you can put a conditional show on the Back button depending of the value of the variable.

I hope it helps.

Carlos

Re: Placing buttons in container tabs, conditional visibility

maxgro — Thu, 29 May 2014 19:03:38 GMT

perhaps it helps

create a grid container (2x1 or 1x2)

add the pie chart and the button

add this new container to the existing container

container --> tab1

--> tab2

--> tab3 = grid container --> pie chart

--> button

Re: Placing buttons in container tabs, conditional visibility

Thu, 29 May 2014 20:09:22 GMT

Hi Carlos,

I like this idea, would you mind providing an example of the formulas for the conditional show? I am very new

Re: Placing buttons in container tabs, conditional visibility

Fri, 30 May 2014 17:27:08 GMT

Does anyone else know what this formula would look like?

Re: Placing buttons in container tabs, conditional visibility

Fri, 30 May 2014 17:54:23 GMT

For the buttons, you would need to give them an action to set the value for a variable you set.

Then for the container, go to the layout tab of presentation and set show to "conditional" and link it to the appropriate variable

Re: Placing buttons in container tabs, conditional visibility

Fri, 30 May 2014 18:01:10 GMT

Hi Robert,

Thank you for your response. I understand what you mean, but my problem is I am so new that I don't even know how 'to give them an action to set the value for a variable you set'. Would you mind explaining this a little further?

I'm very new to Qlikview

Re: Placing buttons in container tabs, conditional visibility

Fri, 30 May 2014 18:04:00 GMT

Its no problem at all, can you share your qvw and maybe I can be a little more helpful?

Re: Placing buttons in container tabs, conditional visibility

Fri, 30 May 2014 18:11:09 GMT

Unfortunately my business will not allow me to share the qvw at this time, but thank you so much for offering to help.

I will try to figure out independently how to create an invisible button on the container tab, with an action to set the value of a variable.

Re: Placing buttons in container tabs, conditional visibility

Fri, 30 May 2014 18:15:54 GMT

Create a variable:

Go to settings-> variable overview and add a variable

Create a text object (this will be the button), give it an action to set the value of a variable (its under the external category)

Then, go to the layout of your button to conditionally show it based on whatever you named your variable

Re: Re: Placing buttons in container tabs, conditional visibility

Fri, 30 May 2014 18:25:10 GMT

Here's an example of what I mean. Click the buttons to make the other objects appear and disappear.

Re: Re: Placing buttons in container tabs, conditional visibility

Thu, 12 Jun 2014 14:07:45 GMT

Hi Robert,

It worked, this is great! But my problem now is that while I can make the text objects transparent, they don't work when I put them on top of the container tabs, or the container tabs don't work. I can't get them to both work with one click.