Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
In QlikView you can't get data directly from one object to another. You need to use the same Calculated Fields in another object.
It's not a straightforward way but you could export your pivot into a excel- or txt-file and load it again.
- Marcus