topic Re: Bar graph vs stacked bar graph? in QlikView

Bar graph vs stacked bar graph?

Mon, 15 Dec 2014 21:45:28 GMT

I would like to be able to toggle between a regular bar graph and a stacked bar graph. Is there a way do this?

Re: Bar graph vs stacked bar graph?

m_woolf — Mon, 15 Dec 2014 22:47:27 GMT

Make both charts. Then use a variable to show or hide the charts as needed.

Re: Bar graph vs stacked bar graph?

jduenyas — Tue, 16 Dec 2014 01:17:31 GMT

You can put this code in your Edit module

Sub ChangeChart()
         set chart = ActiveDocument.GetSheetObject("NAME OF YOUR CHART")
          set p = chart.GetProperties
          if p.ChartProperties.BarModeStacked = True then
                 p.ChartProperties.BarModeStacked = false
          else
                 p.ChartProperties.BarModeStacked = True
          End if
         chart.SetProperties p
End sub

Then you can set a button and its action should point to this Macro.

Each click will toggle between stacked or grouped

Hope it helps.

Re: Bar graph vs stacked bar graph?

rwunderlich — Tue, 16 Dec 2014 01:39:25 GMT

If you plan to use a macro that calls chart.SetProperties in the Server environment, please take note of this warning from section 80.2 of the Ref Guide.

"The following types of functionality are not to be used in the QlikView Server environment , as they may

cause unexpected results:

- Layout operations acting on the properties of sheets and sheet objects via SetProperties"

-Rob