Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
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?


2 Replies

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

MVP & Luminary
MVP & Luminary

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

- Marcus