topic Reference to a value from another object in QlikView

Reference to a value from another object

Wed, 03 Mar 2010 14:13:19 GMT

Hi everyone, is there any way to set as a new expression in a pivot table, the value that another pivot table has in a specific cell?

Thanks a lot

Reference to a value from another object

johnw — Wed, 03 Mar 2010 23:12:01 GMT

I don't believe so, but would be happy to be proven wrong.

Reference to a value from another object

Thu, 04 Mar 2010 07:20:50 GMT

Ok Thanks

Reference to a value from another object

wizardo — Thu, 04 Mar 2010 13:31:41 GMT

hi there,

as far as i know it is only posible via macro code. check the apiguide for the methods: getcell, getcells, getcells2.

i used it once and its bit tricky.

best is if you make a hidden sheet with a copy of the pivot table and get the cells from there.

i did it long ago before set analysis so i had to clear all selections before i copied the cell, since its location changes when you change selections. but maybe with set analysis you can freeze it or at least be able to recalculate the location again.

if you can get the same value from a straight table i think it will be easier.

its very tricky and dirty but sometimes you need it.

Mansyno

Reference to a value from another object

Thu, 04 Mar 2010 13:59:57 GMT

Ok I´ll try. Thanks.