topic Re: Current selections box on every sheet when exported to excel. in QlikView

Current selections box on every sheet when exported to excel.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Current selections box on every sheet when exported to excel.

Siva_Sankar — Wed, 21 Mar 2018 01:38:03 GMT

I never tested this. QlikTip #1: Transferring Current Selections to Excel-Export (translated)

Re: Current selections box on every sheet when exported to excel.

Anonymous — Wed, 21 Mar 2018 02:23:11 GMT

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.

Re: Current selections box on every sheet when exported to excel.

Siva_Sankar — Wed, 21 Mar 2018 03:26:19 GMT

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

-Siva

Re: Current selections box on every sheet when exported to excel.

paul_scotchford — Wed, 21 Mar 2018 03:31:19 GMT

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

Re: Current selections box on every sheet when exported to excel.

Anonymous — Wed, 21 Mar 2018 03:34:06 GMT

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

Re: Current selections box on every sheet when exported to excel.

paul_scotchford — Wed, 21 Mar 2018 03:37:04 GMT

Yes.

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

Re: Current selections box on every sheet when exported to excel.

Anonymous — Wed, 21 Mar 2018 03:39:51 GMT

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

Re: Current selections box on every sheet when exported to excel.

Anonymous — Wed, 21 Mar 2018 03:40:53 GMT

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

Re: Current selections box on every sheet when exported to excel.

Siva_Sankar — Wed, 21 Mar 2018 03:42:52 GMT

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

Re: Current selections box on every sheet when exported to excel.

Anonymous — Wed, 21 Mar 2018 03:45:13 GMT

Thanks for the app, I'm already using a macro to export 5 different objects to 5 tabs. How can I merge these two?

Re: Current selections box on every sheet when exported to excel.

paul_scotchford — Wed, 21 Mar 2018 03:45:50 GMT

I did not see an attached .qvw , I just tested using my own app at the office and made a suggestion as you saw here.