Button

[#1]

Hi Guys

I want to hide and show the pivot table on clicking the button ??????

please send some solution

[CELAMBARASAN]

Hi,

     Look the below thread for Kaushik Solution.

     http://community.qlik.com/message/132294#132294

Celambarasan

[#3]

Hey

Can i minimize and maximize also on the click of the button

[CELAMBARASAN]

Hi,

     Button properties-->Actions tab-->use Minimize object for minimize and use Maximize object for maximize

     Enter object ID of the Chart to minimize or maximize in the Object ID field.

Celambarasan

[jagannalla]

Yes you can..

Button -> action -> External ->Run macro -> give the function name

For Maximize use this macro code:

Sub Maximize

ActiveDocument.GetSheetObject("CH03").Restore

End Maximize

For Minimize use this macro code:

Sub Minimize

ActiveDocument.GetSheetObject("CH03").Minimize

End Maximize

[jagan]

Hi,

Hope attached file helps you.

Regards,

Jagan.

[Gabriel]

Hi Manish,

I sugest you watch this clip

Regards,

Gab

[#8]

Hi Manish,

Hope attached file helps you.

Regards,

Sampath Kumar G

[#9]

Hi Manish,

In Chart properties, under the layout tab you will see show section which has 2 choices Always and conditional.

Conditional show works to show chart only when the given condition is satisfied.

When you want to do it with a button then the easiest way will be to make a variable say v_test give it a default value of 0.

in the Show section (under the layout) of tha chart put condition  if(v_test = 1,1,0)

Create a button then in button properties, go to the action tab and click on add button.

Select external as action type and set variable as action.

in variable name, give the name of the created variable e.g v_test and in value put condition as if(v_test = 0,1,0)

So, if your table is hidden clicking on button will show it and if it is shown than clicking on button will hide it.

Since, it will be toggling of the value of the variable between 1 and 0 which in turn will affect your layout show condition of the chart.

The same way you can change text of your button between show table and hide table.

Hope this helps. Let me know if any query.

..

Ashutosh