Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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