topic Macro Set still show total on top in QlikView

Macro Set still show total on top

MarcoARaymundo — Wed, 23 May 2018 15:25:06 GMT

Hi! does anyone know how?

Re: Macro Set still show total on top

MarcoARaymundo — Thu, 24 May 2018 13:47:59 GMT

sub StillShowTotalOnTop_ON()

chartArray = Array("CH23","CH25")

For Each chart In chartArray

set chart = ActiveDocument.GetSheetObject(chart)

set chartP = chart.GetProperties

chartP.ChartProperties.ShowTotalWithInsideValues = true

chart.SetProperties chartP

Next

end sub

sub StillShowTotalOnTop_OFF()

chartArray = Array("CH23","CH25")

For Each chart In chartArray

set chart = ActiveDocument.GetSheetObject(chart)

set chartP = chart.GetProperties

chartP.ChartProperties.ShowTotalWithInsideValues = false

chart.SetProperties chartP

Next

end sub