5 Replies Latest reply: Aug 23, 2016 1:47 AM by damitha weerasinghe RSS

    how to minimize one chart and place another chart by one click



      I have two charts in my sheet , with the help of a button click, i need to place my 2nd chart in the place of 1st chart(1st chart should be minimized) and when i again click the Button my 1st chart has two come into the place of 2nd(now,2nd should be minimized).

      How can i do this.


      Please check the attachment for Better Understanding .



      Thanks in Advance,


        • Re: how to minimize one chart and place another chart by one click
          anant dubey

          create a button object then on button right click properties

          add action -> layout-> minimize object give Id of first object


          similarly create another button  object for secod object


          add action -> layout-> minimize object

          give Id of second obect.


          on each object go out to cation tab and check auto minimize



          • Re: how to minimize one chart and place another chart by one click
            Gysbert Wassenaar

            You can use a variable to show/hide the charts by clicking a button. See attached qvw.

            • Re: how to minimize one chart and place another chart by one click

              Hi Kumar,


              Please check out this link below , its very informative





              You might think that there is not much to say about buttons in QlikView. If so you are probably not thinking much beyond a shiny lozenge of a thing that invites you to Clear Current Selections. I’m here to convince you otherwise.

              Don’t Waste Space

              The first thing to say here is that a Clear Current Selections button is totally redundant. That button is built right into the QlikView UI in Desktop and both Access Point versions. The same is true of Back, Bookmarks and (unless you have hidden your tabs) Next and Previous Tab buttons. Save yourself some space for some more analysis and don’t waste space with these buttons.

              Default Button Style

              In my opinion shiny lozenges take far more space up than they need to and are visually distracting. You should not use these unless you really have to (i.e. your client or user insists).

              Many objects can be Buttons

              Anything that supports Actions can be a button. The lowly Text Area serves this purpose admirably, and if you have to use a gauge in your app, at least make it useful by making it clickable. A text box with no borders or shading provides a clickable line of text – like the ones that have served web pages so well for many years now.

              With the use of dynamic colours you can have traffic light dashboard components that can also be useful for triggering actions (such as a dive to detail). Simple shading behind your text can make a useful toggle switch in your app.

              Using Actions For Hiding Sheets

              Here are some examples of text boxes performing the actions of buttons. These examples place values into variables, which are then used to do something dynamic in the app.

              In most of the QlikView apps I produce I have some tabs for system data that is hidden from most users. To implement this I set a variable in the load script:

              let vShowDev = 0;

              On the front sheet there is then a text box that has dynamic text:

              =if (vShowDev = 0, 'Show', 'Hide') & ' Development Tabs'

              And finally there is an Action to set the value of the variable:

              =if(vShowDev = 0, 1, 0)

              The toggle on the screen looks inconspicuously like this:

              Show Development Tabs

              All that is left then is to put the Conditional Show criteria on the correct sheets. The code for this is simply:

              vShowDev = 1

              Show Different Views Based On Variable Values

              Another example of a show/hide toggle is where you want to swap between different charts or tables. Natively QlikView has the Auto-Minimise tick box and more recently the Container, but I am not a fan of using these. With a Conditional Show one object can be hidden and be replaced with a number of other objects.

              To do a multi-way toggle I will set color variables up in the load script:

              let vColHighlight = rgb(210, 255, 210); let vColNoHighlight = rgb(255, 255, 255);

              And default a display variable:

              let vViewMode = 'Dashboard';

              Text Areas are then required for each of the values you wish to set. Each text box simply has the legend of the view mode, and an Action to set the variable to the correct value:

              Set View Mode To Analysis

              The final step is to highlight which button is presently active. This is done by setting the Background Colour on each Text Object  to a dynamic colour with the following code:

              if(vViewMode = 'Analysis', $(vColHighlight), $(vColNoHighlight))

              With a bit of sizing and alignment the row of toggle buttons should look a bit like this:

              Dashboard Analysis Detail

              Again, a simple Show Conditional expression is required on each chart to dictate under which heading it displays.   The code for this will be:

              vViewMode = 'Analysis'
              • Re: how to minimize one chart and place another chart by one click
                damitha weerasinghe

                Hi ,


                The easiest way is enabling Auto minimize option.