3 Replies Latest reply: Nov 15, 2010 3:49 PM by Karl Pover RSS

    show a pivot table when a chart is maximize

    jose fernandez

      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
          Neil Miller

          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
            Karl Pover

            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
              Karl Pover

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

              Regards.