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

[#1]

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!

[fosuzuki]

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