QlikTip #1: Transferring Current Selections to Excel-Export (translated)

While driving this blog only in German the most viewed article was “QlikTip #1 – Export the current celections to Excel”.
So this will also be the first article translated to English.

(The original German article can be found at http://www.qlikblog.at/9/tip-statusboxauswahlstatus-in-excel-export-integrieren/)

The functionality in QlikView that any object-content can be easily exported to Excel is very practical and often used.
But now it is also a common requirement that the generated Excel sheet should also contain some information which selections have been made in QlikView, one just need to know on which data the results in Excel are based on …
Good news! This feature is available in QlikView, although it is not enabled by default:

Go into the user settings (menu: Settings” => “User Preferences” or Ctrl+Alt+U) and then on the “Export“)
Now you have to check the option “BIFF Export” in the section “Selection Stamps in Export”

User Settings in QlikView Windows Client for enabling to transfer the current selections to Excel

User Settings in QlikView Windows Client for enabling transferring the "Current Selections" to Excel

After having set these options the “Current Selection” will be exported at the end of your Excel-file:

Exporting an object in QlikView to Excel

Current selections of QlikView shown in Excel

Does this also work on the QlikView Server?

So far so good, but what happens when you open the document using the IE plugin via the Access Point on the QlikView Server?

Of course, nothing at all, it is a user setting, so this setting, we have set for the Windows client of QlikView is not available for the IE-Plugin.

A quick glance into the user settings in IE plug shows that this assumption is correct and that this option can be set on the server as well:

User preferences in the QlikView IE-Plugin

Under Menu => User Preferences (or Ctrl+Alt+U) and “Export” we find again the familiar dialogue, the “BIFF Export” is also disabled by default:

Now you can, of course, can waive the end user to select this option or not, if this is not desired, you can explicitely set this option by setting a special registry key to the user.
This registry-key called “[HKEY_CURRENT_USER\Software\QlikTech\QlikOcx\Settings 7]

The attached registry-file could for example be delivered with other settings during automated installation of QlikView or other user related startup-tasks within your environment:

[HKEY_CURRENT_USER \ Software \ QlikTech \ QlikOcx \ Settings 7]
"SelectionStampInBIFFExport" = "1"

Related Downloads

QlikView application for testing this QlikTip
Registry File for setting the user settings automatically

Possibly related posts:

By Stefan Walther 10 Comments
This entry was posted in QlikTips

Published: January 19, 2010
and tagged current selections, Excel, Export, IE-Plugin, QlikView, registry, Settings, user settings. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

7 Comments

Sergio

Posted August 6, 2010 at 12:19 | Permalink

Dear Stefan,

I write in english ’cause Ich spreche wenig Deutsch.
That’s fine, but what’s about the need to have something more ?
I mean is there any macro example or reference to create your own excel from a trigger ?

Common is the formatted reporting created in excel.
So it’s easy to extract a table selection to Excel
(eg :
dim o Set o = ActiveDocument.GetSheetObject(objectId) o.ExportBiff filePath
)

But what about the possibility to extract several tables and formatting it as u want in excel ?

Have u never faced with this kind of request ?
Regards
Sergio

- Stefan Walther
  
  Posted February 4, 2011 at 00:01 | Permalink
  
  Hi Sergio,
  
  yes I have a solution for that
  
  I’ll post this on this blog within the next weeks …
  If you need the solution in the meantime, just drop me a mail …
  
  Regards
  Stefan
  
  - Stalin
    
    Posted March 4, 2011 at 11:41 | Permalink
    
    Hi Stefan,
    Can you please send me the solution for how to export selected data from several tables as well as the current selection to a excel file through a button.
    
    Thanks,
    Stalin
    
    - Stefan Walther
      
      Posted March 12, 2011 at 01:53 | Permalink
      
      Here it is:
      
      http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/
      
      Regards
      Stefan
      
Dinesh Sharma

Posted February 8, 2011 at 20:02 | Permalink

thanks much for sharing

gerhard

Posted June 1, 2011 at 09:52 | Permalink

Da sieht man wieder mal, wie sehr scheinbare Kleinigkeiten das Leben erleichtern können! Genau diese Funktionalität stand schon lange auf der Wunschliste unserer User!
Danke und lg

- Stefan Walther
  
  Posted June 1, 2011 at 13:02 | Permalink
  
  Nice to hear that!
  
  Regards
  Stefan

3 Trackbacks

By QlikCommunity | QlikTip #19: Suppressing Macro-Security (Module Security) Dialog on QlikView-Server/QlikView-Documents - The QlikView Blogroll on September 29, 2010 at 19:07

[...] QlikTip #1: Transferring Current Selections to Excel-Export (translated) [...]
By QlikCommunity | QlikTip #3: Check whether a field exists or not (translated and improved) - The QlikView Blogroll on October 7, 2010 at 10:19

[...] QlikTip #1: Transferring Current Selections to Excel-Export (translated) [...]
By QlikTip #1: Statusbox/Auswahlstatus in Excel-Export integrieren | qlikblog.at on March 18, 2011 at 13:49

[...] wurden, ideal wäre ein gleichzeitiger Export der Auswahlbox nach Excel.Note: There is also an english version of this article available …Diese Funktionalität steht in QlikView zur Verfügung, wenngleich diese in den [...]