topic get full data of PivotTable in QlikView https://community.qlik.com/t5/QlikView/get-full-data-of-PivotTable/m-p/511102#M1235472 <HTML><HEAD></HEAD><BODY><P>Hello together,</P><P></P><P>I have in my QlikView Applications severals Pivottables. I want to export the data of the Pivottable by C# OCX. Now I have the problem that I get not the full table data, some columns are collapsed, how can I open these columns automatically.</P><P></P><P>Application qvApp = new Application();</P><P>Doc qvDoc = qvApp.OpenDoc(@"PATH_TO_QV_APP");</P><P></P><P>//get object</P><P>SheetObject qvObject = qvDoc.GetSheetObject("QV_OBJECT_ID");</P><P>// cast object to pivottable</P><P>PivotTableBox pivottable= (PivotTableBox)qvObject;</P><P>//file path to save</P><P>pivottable.Export("FILE_PATH", ";");</P></BODY></HTML> Mon, 26 Jan 2026 16:26:21 GMT 2026-01-26T16:26:21Z get full data of PivotTable https://community.qlik.com/t5/QlikView/get-full-data-of-PivotTable/m-p/511102#M1235472 <HTML><HEAD></HEAD><BODY><P>Hello together,</P><P></P><P>I have in my QlikView Applications severals Pivottables. I want to export the data of the Pivottable by C# OCX. Now I have the problem that I get not the full table data, some columns are collapsed, how can I open these columns automatically.</P><P></P><P>Application qvApp = new Application();</P><P>Doc qvDoc = qvApp.OpenDoc(@"PATH_TO_QV_APP");</P><P></P><P>//get object</P><P>SheetObject qvObject = qvDoc.GetSheetObject("QV_OBJECT_ID");</P><P>// cast object to pivottable</P><P>PivotTableBox pivottable= (PivotTableBox)qvObject;</P><P>//file path to save</P><P>pivottable.Export("FILE_PATH", ";");</P></BODY></HTML> Mon, 26 Jan 2026 16:26:21 GMT https://community.qlik.com/t5/QlikView/get-full-data-of-PivotTable/m-p/511102#M1235472 2026-01-26T16:26:21Z