1 Reply Latest reply: Feb 3, 2012 8:21 AM by Fernando Suzuki RSS

    How to hide a column in a table but show it in xls export

      I've been searching and I know how to conditionally hide/show columns, but I don't know how to hide a column in the Qlikview application ( Table )

      but yet to include it when users click the export to XLS button.

       

      Is this even possible?  Or do I need to create a secondary hidden table with a button to export (if that is possible).

       

      Thanks in advance for your insights!

        • How to hide a column in a table but show it in xls export
          Fernando Suzuki

          If you are using QV11, both Straight Table and Pivot Table can be configured to hide columns. If u want to hide a dimension, go to Chart Properties > Dimensions > Select the Dimension u want to hide > Enable Conditional > Insert the condition.

           

          If u are using QV10 or previous, only the Straight Table can be configured to hide columns. Go to Chart Properties > Presentation > Select the Column u want to hide > Conditional > Insert the condition.

           

          The Table Box object cannot be configured to hide columns.

           

           

          If u opt for the 'button to export' approach, the macro code is:

               set obj = ActiveDocument.GetSheetObject("CH01")

               obj.SendToExcel

           

           

          Hope this points u to the right direction.

          Regards,

          Fernando