Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have five straight tables, I used a macro to create a single excel file with five straight tables in five sheets.
Now I want the current selections box on top of each table in every sheet.
Link I used to create the macro QlikTip #32: Exporting multiple QV objects to a single Excel document
Any help is appreciated,
SU.
I never tested this. QlikTip #1: Transferring Current Selections to Excel-Export (translated)
Using that tip, the current selections are printing at bottom. I want them to print at top of the table. For one tab I have 100K records, user cant scroll all the way to bottom to see the selections.
Ok. Find the attached application using macro to export to excel with current selection at the top.
-Siva
Try sorting the column with the selections on , in my example it was column A , result sample below...
I have 5 tabs, do I have to sort on all tabs?
Yes.
But one would ask why there is the need to export so much data from QlikView into Excel ?
I already have a macro to export 5 different objects to 5 tabs. How can I merge these two?
Users share that report with people outside the company during presentations.
did you try the application attached by me in the above thread?