Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
francis_gr
Creator
Creator

show a pivot table when a chart is maximize

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

1 Solution

Accepted Solutions
pover
Partner - Master
Partner - Master

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

Regards.

View solution in original post

3 Replies
Not applicable

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.

pover
Partner - Master
Partner - Master

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.

pover
Partner - Master
Partner - Master

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

Regards.