Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can we show the value of a particular column of particular chart in text object, without using expression in the text object.Please help me out......
Hi
If you would like to get the value from the chart object, then I am afraid that the answer is no. There is no way to retrieve the value from the chart. You would have to calculate the value again in the text object.
Regards
Jonathan
is macro is heplful for this problem
You can use a macro if you really need to. The below will show a message box displaying the value in the third column of the second row of chart CH02. You should be able to adapt this to your needs.
sub GetCellValue()
set obj = ActiveDocument.GetSheetObject( "CH02" )
w = obj.GetColumnCount
h = obj.GetRowCount
set CellMatrix = obj.GetCells2(0,0,w,h)
Row = 2
Coll = 3
msgbox(CellMatrix(Row)(Col).Text)
end sub
Can you provide me a test application for this macro
See attached qvw
hii...i am uploading a qvw in which there is a button call qlik ..on that button i called two macro that give me two different value.... my question is that can we show the result of those macro in text box as a sum of that...
example
one first click value is 26
one second click value is 4
so in text box the result should come as 30 on single click
I want this value in text box....can u send me macro related to this
sub SetText2CellValue()
set obj = ActiveDocument.GetSheetObject( "CH02" )
w = obj.GetColumnCount
h = obj.GetRowCount
set CellMatrix = obj.GetCells2(0,0,w,h)
R = 6
C = 2
set mytext = ActiveDocument.GetSheetObject( "TX01" )
set prop = mytext.GetProperties
prop.Layout.Text.v = CellMatrix(R)(C).Text
mytext.SetProperties prop
end sub
This macro is very useful.can we show the total value in the text box