Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
balrammahato204
Creator
Creator

Macro to get the Values on Chart

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

0 Replies