Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
I want to hide and show the pivot table on clicking the button ??????
please send some solution
Hi,
Look the below thread for Kaushik Solution.
http://community.qlik.com/message/132294#132294
Celambarasan
Hey
Can i minimize and maximize also on the click of the button
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
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
Hi,
Hope attached file helps you.
Regards,
Jagan.
Hi Manish,
Hope attached file helps you.
Regards,
Sampath Kumar G
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