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: 
Not applicable

Showing data in text object with refernce to chart

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......

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qvw


talk is cheap, supply exceeds demand

View solution in original post

14 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

is macro is heplful for this problem

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

Can you provide me a test application for this macro

Gysbert_Wassenaar

See attached qvw


talk is cheap, supply exceeds demand
Not applicable
Author

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

Not applicable
Author

gwassenaar 

I want this value in text box....can u send me macro related to this

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

This macro is very useful.can we show the total value in the text box