Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Re: Showing data in text object with refernce to chart

See attached qvw


talk is cheap, supply exceeds demand
14 Replies
MVP
MVP

Re: Showing data in text object with refernce to chart

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

Re: Showing data in text object with refernce to chart

is macro is heplful for this problem

Re: Showing data in text object with refernce to chart

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

Re: Showing data in text object with refernce to chart

Can you provide me a test application for this macro

Re: Showing data in text object with refernce to chart

See attached qvw


talk is cheap, supply exceeds demand
Not applicable

Re: Showing data in text object with refernce to chart

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

Re: Showing data in text object with refernce to chart

gwassenaar 

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

Re: Showing data in text object with refernce to chart

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

Re: Showing data in text object with refernce to chart

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

Community Browser