0 Replies Latest reply: Jun 26, 2013 7:27 AM by Steffen Prendke RSS

    get full data of PivotTable

    Steffen Prendke

      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", ";");