topic Re: Button in QlikView

Button

Tue, 17 Apr 2012 12:10:33 GMT

Hi Guys

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

please send some solution

Button

CELAMBARASAN — Tue, 17 Apr 2012 12:21:46 GMT

Hi,

Look the below thread for Kaushik Solution.

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

Celambarasan

Button

Tue, 17 Apr 2012 12:35:43 GMT

Hey

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

Button

CELAMBARASAN — Tue, 17 Apr 2012 12:45:12 GMT

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

Button

jagannalla — Tue, 17 Apr 2012 12:48:45 GMT

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

Re: Button

jagan — Tue, 17 Apr 2012 12:57:21 GMT

Hi,

Hope attached file helps you.

Regards,

Jagan.

Button

Gabriel — Tue, 17 Apr 2012 15:27:11 GMT

Hi Manish,

I sugest you watch this clip

Regards,

Gab

Re: Button

Wed, 18 Apr 2012 10:14:15 GMT

Hi Manish,

Hope attached file helps you.

Regards,

Sampath Kumar G

Button

Wed, 18 Apr 2012 10:32:02 GMT

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