topic Re: Change Properties for maximized chart and normal chart in QlikView

Change Properties for maximized chart and normal chart

Fri, 22 Jul 2016 07:56:20 GMT

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?

Re: Change Properties for maximized chart and normal chart

MK_QSL — Fri, 22 Jul 2016 08:16:07 GMT

Custom chart features / hide or show data points on chart in QlikView - YouTube

Re: Change Properties for maximized chart and normal chart

anagharao — Fri, 22 Jul 2016 09:10:18 GMT

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)