Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change Properties for maximized chart and normal chart

Hi

  I want change properties for one chart in maximize mode and and normal mode ,different properties like ..i Need to show values on data points in maximize mode ,i don't want to show values on data points in normal mode is it possible?

1 Solution
2 Replies
anagharao
Creator II
Creator II

To add to the above video:

Step 1: Create Chart and List box

Step 2: Add in VB script:

      Public Sub SetNumbersOnChart()

        Set MyGraph = ActiveDocument.GetSheetObject("CH01")    

                Set MyGraphProp = MyGraph.GetProperties    

                Set MyExpsToggle = MyGraphProp.Expressions.Item(0).Item(0).Data.ExpressionVisual

              

                IF MyExpsToggle.NumbersOnBars = False Then

                    MyExpsToggle.NumbersOnBars = True

                Else

                    MyExpsToggle.NumbersOnBars = False

                End IF

        MyGraph.SetProperties MyGraphProp

    End Sub

Step 3: Call the above macro when the field of the list box is selected

    For this you would have to set a on select Action for that field in document properties. (Screen shots attached)