Macro to get the Values on Chart

balrammahato204 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Please help me on below

Below Macro functionality is once i am providing the input for row and column (Using Inputbox) from the Qlikview UI then corresponding text box i am getting value of the corresponding row and column .

Can someone enhance this macro so i can capture all the columns values inside a Chart.

Please find the attached screenshot where i kept the existing Macro functionality screen shot and aspect Functionality Screenshot.

Sub ChangeV1

set table = ActiveDocument.GetSheetObject( "TB01" )

CellRect = ActiveDocument.GetApplication().GetEmptyRect()

CellRect.Width = table.GetColumnCount

CellRect.Height = table.GetRowCount

set CellMatrix = table.GetCells(CellRect)

r = Activedocument.variables("r").Getcontent.String

c = Activedocument.variables("c").Getcontent.String

set cell = CellMatrix.Item(r).Item(c-1)

Activedocument.variables("v1").SetContent cell.text,1

End Sub

Thanks and Regards

Balram

topic Macro to get the Values on Chart in QlikView

Macro to get the Values on Chart