Qlik Community

QlikView Integration

Discussion Board for collaboration on QlikView Integration.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

get full data of PivotTable

Hello together,

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.

Application qvApp = new Application();

Doc qvDoc = qvApp.OpenDoc(@"PATH_TO_QV_APP");

//get object

SheetObject qvObject = qvDoc.GetSheetObject("QV_OBJECT_ID");

// cast object to pivottable

PivotTableBox pivottable= (PivotTableBox)qvObject;

//file path to save

pivottable.Export("FILE_PATH", ";");

Community Browser