Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Current selections box on every sheet when exported to excel.

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.

11 Replies
Anonymous
Not applicable
Author

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.

Siva_Sankar
Master II
Master II

Ok. Find the attached application using macro to export to excel with current selection at the top.

-Siva

paul_scotchford
Specialist
Specialist

Try sorting the column with the selections on , in my example it was column A , result sample below...

Anonymous
Not applicable
Author

I have 5 tabs, do I have to sort on all tabs?

paul_scotchford
Specialist
Specialist

Yes.

But one would ask why there is the need to export so much data from QlikView into Excel ?

Anonymous
Not applicable
Author

I already have a macro to export 5 different objects to 5 tabs. How can I merge these two?

Anonymous
Not applicable
Author

Users share that report with people outside the company during presentations.

Siva_Sankar
Master II
Master II

did you try the application attached by me in the above thread?