topic show a pivot table when a chart is maximize in QlikView

show a pivot table when a chart is maximize

francis_gr — Mon, 15 Nov 2010 20:01:20 GMT

Hi!!

Is it possible to show a pivot table only when a bar chart is maximize. If i minimize the chart, the pivot table must minimize too.

Thanks

show a pivot table when a chart is maximize

Mon, 15 Nov 2010 20:36:52 GMT

Not really. Unfortunately, there are no OnMinimize or OnMaximize events. When you minimize an object, there isn't an easy way to then fire a macro or otherwise handle the changes.

There is a IsMinimized property in the API, so you could check the status of an object using a macro. The problem is without the events, you have no way of forcing the macro to run.

One way around this is to not use the Minimize/Maximize functionality built into QlikView, but instead use a button to Minimize an object. When this button is pressed, minimize the object and then do the other actions that you require. You could even make the button display what looks like a normal minimize icon and place it directly over the minimize button on a chart. That's a lot of work though.

I've pretty much given up on this type of functionality until we have the necessary events. It's just too much work otherwise.

If you search around, you can probably find some other discussions on this subject and get some tips on how others are handling it.

show a pivot table when a chart is maximize

pover — Mon, 15 Nov 2010 20:37:44 GMT

There are a couple things you can do, but it almost always comes down to using a button with actions see there is no trigger OnMinimize for an object.

For the button/action solution you create one button to minimize and another to restore. A variable controls which button is enabled. You can also hide/show buttons depending on the same variable. You can always show/hide the chart and table instead of minimizing and restoring which you control by changing the controlling variable in a button.

See the attached example for ideas.

Regards.

show a pivot table when a chart is maximize

pover — Mon, 15 Nov 2010 20:49:33 GMT

Here's the best possible solution using the Show conditional option and just 1 button that appears somewhat like a minimized chart.

Regards.