Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
MarcoARaymundo
Creator III
Creator III

Macro Set still show total on top

Hi! does anyone know how?

1 Solution

Accepted Solutions
MarcoARaymundo
Creator III
Creator III
Author

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

View solution in original post

1 Reply
MarcoARaymundo
Creator III
Creator III
Author

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