topic Use a Column into another pivot in QlikView

Use a Column into another pivot

Anonymous — Thu, 27 Dec 2012 13:57:25 GMT

Hi all,

I'm looking for a methode or function to get an expression from my first Pivot (CH1) into my other pivot (CH2) , is't possible ?

regards

Re: Use a Column into another pivot

Gysbert_Wassenaar — Thu, 27 Dec 2012 13:59:16 GMT

You can copy and paste the expression or you can put the expression in a variable and use the variable in both pivot tables. What you cannot do is reference cells, rows or columns from one pivot table in another pivot table.

Re: Use a Column into another pivot

Anonymous — Thu, 27 Dec 2012 14:04:41 GMT

yeah, I forgot to write it, but my expression is calculated successive columns of my first pivot, i used column(1) for exemple, so I can not copy only phrase I intend to use.

Re: Use a Column into another pivot

Anonymous — Thu, 27 Dec 2012 14:21:03 GMT

Well,

I did it using a variables.

but, if you have a tips to use a column from another pivot, i'm gonna take it

regards

Re: Use a Column into another pivot

Anonymous — Sun, 30 Dec 2012 15:20:41 GMT

Please could you provide some steps on how to do this. I have a Pivot with two calculated columns and I would like to compare the values with data from another table.

Thanks

Matt