Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Referencing a straight chart cell/column

Hi,

Is there a way to reference a cell or column of a straight chart to obtain the contents/values for use in another object?

I have several straight charts with calculated fields and totals - I want to be able to add a text object that displays the sum of totals from each chart without having to recreate all the calculations.

I was hoping to be able to write something like:

=CH01.columnB.total + CH02.columnB.total + .....

where CH01 and CH02 are the Object ID's.

Is anything like this possible?

Thanks

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

4 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Unfortunately NO

Not applicable
Author

There is not.  You will need to use the calculation or store the calculation in a variable and reference the variable.

O11235
Contributor III
Contributor III

Hi

Try the "column(column no.)" command. Have a look in the help file.

O11235
Contributor III
Contributor III

p.s. Column no. refers to the columns with an expression within.