topic Re: Using single button , need to toggle between two straight table in QlikView

Using single button , need to toggle between two straight table

Thu, 14 Jun 2012 06:06:56 GMT

Hi,

I have two Straight table in the attached applicaion. With the help of a button, I want to hide one Table and activate another table. For example, If table 1 is open, then on pressing the button, table 1 should go and table 2 should open. Again, If I press the button , table 1 should open and 2 should hide.

Thanks,

Gerard

Re: Using single button , need to toggle between two straight table

lironbaram — Thu, 14 Jun 2012 06:25:15 GMT

check this example in the first sheet i used a button

in the button you change the value of a variable look in the button triggers

for each table i assigned a conditional show in the layout tab.

the second sheet is what i prefer to use is using a container with no need for variables

hope it helps you

Re: Using single button , need to toggle between two straight table

rohit214 — Thu, 14 Jun 2012 06:28:48 GMT

Hi Gerard

please find the attachment

thanks& regards

rohit

Re: Using single button , need to toggle between two straight table

Thu, 14 Jun 2012 06:43:39 GMT

Hi,

Liron it was great and awesome. The 2nd sheet that you have created was very useful, this is how i want , so that moreover it is looking like a spinner, that we can select any table we want. The problem is ,in my client system they are using qlikview 9, so container object is not supprted. Is there any other way like wat u have created. So that it will work in QV 9.

Regards,

Gerard.

Re: Using single button , need to toggle between two straight table

Thu, 14 Jun 2012 06:44:47 GMT

Hi Rohit,

It is working fine, thanks for your valuable time.

Regards,

Gerard

Re: Using single button , need to toggle between two straight table

lironbaram — Thu, 14 Jun 2012 07:13:50 GMT

hi look at the second sheet it works with buttons but looks like a tab

Re: Using single button , need to toggle between two straight table

Thu, 14 Jun 2012 11:16:37 GMT

Thanks liron,

I will go with option one. But when i have multiple charts as in the attached application.

When i select chart 1 , it will open up. When i select chart 2 , chart 1 will be minimized and chart 2 will be seen. Button is used to toggle between invoice chart and spend chart. So totally there are chart 1, chart2 and a button(used to togglet between invoice and spend chart). Now when i click chart 1 , automatically chart 2 will be minimixed , simillarly i want the other chart either invoice or spend which is opened to be minimized.

So at a time i can see only 1 chart.

Regards,

Gerard