0 Replies Latest reply: Sep 20, 2016 6:04 PM by Ralph Dickie RSS

    Pivot Table Export to Excel - Fill All Columns and Rows

    Ralph Dickie

      HI everyone,

       

      When I export a pivot table from QLIK VIEW I get an export similar to this.  I like it!

       



      2016 Spring2016 Fall
      Sales RepProductsQTYQTY
      Barney GumbleBeer Can Jacket10001200
      Barney GumbleT-Shirts2515
      PrinceSmokin' Jacket15100
      PrinceBatman Album114100

       

      However, when I export the same pivot report to Excel from QLIK Sense I get the following.  Column 1 does not get auto filled.

       



      2016 Spring2016 Fall
      Sales RepProductsQTYQTY
      Barney GumbleBeer Can Jacket10001200
      T-Shirts2515
      PrinceSmokin' Jacket15100
      Batman Album114100

       

       

      Does anyone know how to configure QLIK Sense exports to do this?

       

      Thanks,

       

      Ralph