Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

GetPivotData function on Qlikview

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!

2 Replies
MK_QSL
MVP
MVP

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

marcus_sommer

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

- Marcus