topic GetPivotData function on Qlikview in QlikView

GetPivotData function on Qlikview

Thu, 16 Jul 2015 16:40:45 GMT

Hey guys.

I have created a Pivot Table on Qlikview, which has some calculated fields. I'd like to use the data from these calculated fields they are not available on the database) to create a new Simple Table, something similar to how the GetPivotData function works on Excel.

Is there a similar function on QlikView? If not, how can I get these calculated data from the Pivot to be used on another table?

Thanks!

Re: GetPivotData function on Qlikview

MK_QSL — Thu, 16 Jul 2015 18:25:28 GMT

In QlikView you can't get data directly from one object to another. You need to use the same Calculated Fields in another object.

Re: GetPivotData function on Qlikview

marcus_sommer — Thu, 16 Jul 2015 19:19:14 GMT

It's not a straightforward way but you could export your pivot into a excel- or txt-file and load it again.

- Marcus