Discussion Board for collaboration on QlikView Layout & Visualizations.
I should create a file Excel by macro with two Sheets.
in the firs sheet i should put the one Pivot Table(with more subtotal lines) wihile, in the second sheet,I need to put the current selection.
No problem for the second sheet (current selection) but I have some problems with first sheet:
The client want to have the same format that he have when click on XLS export Button on the grid.
So, is possible to export the table in the sheet first sheet with the same format of the function SendToExcel?
many thanks and best regards :-D