Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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