topic Re: Selections shown when export to excel option? in QlikView

Selections shown when export to excel option?

Mon, 26 Jan 2026 18:19:17 GMT

When you print or export to a pdf, the current selections are shown too. When I export to excel, the current selections are not shown. Can we, and if so how, can we export to excel with the current selections attached too?

Thanks!

Selections shown when export to excel option?

m_woolf — Thu, 16 Feb 2012 20:16:56 GMT

This can be done with a macro:

sub ExportWithSelections
      Set XLApp = CreateObject("Excel.Application")
      XLApp.Visible = True
      Set XLWorkbook = XLApp.Workbooks.Add
      Set XLSheet = XLWorkbook.sheets("Sheet1")
      XLSheet.Range("A3").Select

rem ** copy full chart details to clipboard **
ActiveDocument.GetSheetObject("CH252").CopyTableToClipboard false
XLSheet.Paste ' -4163 'values

XLSheet.Range("J2").Select

rem ** put current selection in J2 **
      ActiveDocument.GetSheetObject("CS12").CopyTableToClipboard true
      XLSheet.Paste ' -4163    'values
      XLApp.Selection.WrapText = False

      set XLSheet = nothing
      set XLWorkbook = nothing
      set XLApp = nothing

end sub

Re: Selections shown when export to excel option?

Thu, 16 Feb 2012 21:12:23 GMT

The only thing is where do I put this macro? If someone is opening the QV document through a web portal, will they beable to use this macro? Can I incorporate it with the QV document so that it will append the selections no matter the version of excell someone open into?

Re: Selections shown when export to excel option?

m_woolf — Thu, 16 Feb 2012 21:18:24 GMT

Tools|Edit Module opens the macro editor.

This macro requires System Access.

It will work if your users are opening with the IEPlugin. I don't know if it will work with Ajax.

Once the macro is entered. You need to create a button object and set the button acrtion to run the macro.

Re: Selections shown when export to excel option?

Fri, 17 Feb 2012 15:27:00 GMT

Sorry mwoolf. I've not made a macro in QV before. When I add it and create a button and set the action of the button to Run Macro with the name of the macro I created, it only opens the edit module window with the macro code.

What am I missing?

Re: Selections shown when export to excel option?

m_woolf — Fri, 17 Feb 2012 15:58:31 GMT

in the code you need to change the "CH252" to the object ID for the chart you want to export

in the code you need to change the "CS12" to the object ID for the selection box you want to export

Re: Selections shown when export to excel option?

Fri, 17 Feb 2012 16:27:03 GMT

Thanks mwoolf. That does work, but what I really want is just when people right click on any chart and choose to export in excel, that it will export with selections.

I know these options exist under document properties. But it doesn't work when I try to download a chart from a dashboard in production.

Re: Selections shown when export to excel option?

Wed, 22 Feb 2012 11:08:42 GMT

Hi Brandon,

Did you try the following on the prod server? : User preferences-Exports-Selection Stamps in Exports- On BIFF exports- checked

Re: Selections shown when export to excel option?

Wed, 22 Feb 2012 14:16:00 GMT

We're still using 10.4, so we don't have Selections Stamps but rather Selections for Current selection box. Clicking those two boxes doesn't work with the production server when you right-click and export to excel though at least not for "Open with AJAX zero footprint" or when you do it with a different browser (It does work with IE plugin.)

Selections shown when export to excel option?

natebrunner — Fri, 20 Apr 2012 14:29:10 GMT

Did you ever come up with a solution to this? I'm wondering the same thing if I can get the selections to appear when sending a table box of data to Excel.

Selections shown when export to excel option?

m_woolf — Fri, 20 Apr 2012 14:33:32 GMT

Selection Box can be exported with a macro....same as charts listed above.

Selections shown when export to excel option?

natebrunner — Fri, 20 Apr 2012 14:39:20 GMT

I realize you can do it with a Macro...was hoping there was a way to do it without Macros. We are on version 9, although hoping to upgrade to 11 this summer. Is it built in functionality in 11 to do it without a Macro?

Selections shown when export to excel option?

Fri, 20 Apr 2012 14:39:38 GMT

Well there is a fix on the support site for AJAX, but it breaks the export selections in IE explorer plugin for us (which was working).

How to Include Current Selectionswhen Exporting to Excel from AJAX

Description

When exporting to Excel you can include the current selections by activating a user setting in IE-plugin/Desktop.
To get the same behavior when using AJAX the same setting needs to be activated server side in the settings.ini file.

Resolution

Stop the service "QlikView Server"
Open the file settings.ini (located in C:\ProgramData\QlikTech\QlikViewServer or C:\Documents and Settings\All users\ApplicationData\QlikTech\QlikViewServer depending on OS)
Add the parameter SelectionStampInBIFFExport=1 in the section labeled [Settings 7]
Save the file
Restart the service "QlikView Server"

Tags

Server/Publisher, AJAX, Export, Excel, Current Selections

Selections shown when export to excel option?

natebrunner — Fri, 20 Apr 2012 14:42:23 GMT

Interesting. Thanks for the help. Weird that it would fix AJAX but break the plugin. I suppose it's better if we just wait until the upgrade.

Selections shown when export to excel option?

brindlogcool — Wed, 25 Apr 2012 16:28:04 GMT

Hi,

I am using ExportEx to export to excel the current selection is getting exported in to excel. I have unchecked the selection timestamp in the user preference but still the current selection is shown. I tried the macro in the Api guide to set the selection time stamp to false. Is ther any way i can stop this

Re: Selections shown when export to excel option?

michaelfreitas — Fri, 04 Apr 2014 20:23:50 GMT

In the development version of QlikView have this option.

Good!

Re: Selections shown when export to excel option?

mayankraoka — Mon, 12 Sep 2016 12:48:08 GMT

Hi,

Can the current selection should be on top possible?

Regards,

Mayank