topic Re: Referencing a straight chart cell/column in QlikView

Referencing a straight chart cell/column

Thu, 24 Apr 2014 13:24:52 GMT

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

Re: Referencing a straight chart cell/column

alexandros17 — Thu, 24 Apr 2014 13:31:59 GMT

Unfortunately NO

Re: Referencing a straight chart cell/column

Thu, 24 Apr 2014 13:32:17 GMT

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

Re: Referencing a straight chart cell/column

O11235 — Mon, 21 Jul 2014 12:51:10 GMT

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

Re: Referencing a straight chart cell/column

O11235 — Mon, 21 Jul 2014 13:20:26 GMT

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