topic Query regarding bar graph in QlikView

Query regarding bar graph

AbhijitBansode — Thu, 03 Mar 2011 06:47:13 GMT

I have an requirement of changing bar chart between Groped and Stacked type.

Is it possible to switch the chart type between grouped and stacked on button click(using single bar chart).

Query regarding bar graph

AbhijitBansode — Thu, 03 Mar 2011 06:52:45 GMT

I have one more requirement for hide and show the value on bars.

Is it possible to hide and show value on bars on button clik(In Single Bar chart)

Query regarding bar graph

maneshkhottcpl — Thu, 03 Mar 2011 07:23:35 GMT

Hi,

As per my understanding u want the macro to show and hide the expression(Bar) on button clik.

If it is correct. Then please refer the application attached.

Query regarding bar graph

deepakk — Thu, 03 Mar 2011 07:28:16 GMT

hi Abhijit,

I found a soln for Stack bar. You can check it out.

Query regarding bar graph

AbhijitBansode — Thu, 03 Mar 2011 07:50:06 GMT

Thank you for solution.

Query regarding bar graph

Thu, 03 Mar 2011 08:13:37 GMT

Hi,

you try this macro to change stacked bar chart to group bar chart and vise-versa

sub changechartmode
set chart = ActiveDocument.GetSheetObject("CH01")
set p = chart.GetProperties
if(p.ChartProperties.BarModeStacked = false) then
p.ChartProperties.BarModeStacked=true
else
p.ChartProperties.BarModeStacked = false
end if
chart.SetProperties p
end sub

Regards,

Yogesh