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 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:
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:
- QlikTip #1: Statusbox/Auswahlstatus in Excel-Export integrieren
Wie kann man die aktuelle Auswahl der Statusbox bei einem Excel-Export ebenfalls nach Excel exportieren. Dieser Artikel zeigt, wie dies nicht nur lokal sondern auch über den QlikView Publisher funktioniert.... - QlikTip #19: Suppressing Macro-Security (Module Security) Dialog on QlikView-Server/QlikView-Documents
When opening documents with macros the end-user will be shown a dialog to define the desired macro-security/module security (in the QlikView Windows Client or the QlikView IE Plugin): But what, If you do not want... - QlikTip # 18: A workaround for passing parameters to QlikView-macros
When calling macros from the user interface you cannot pass a parameter to the function called in QlikView. This behavior is quite annoying …! But the workaround explained here will show you a possibility how...
Mag. Stefan WALTHER
One Comment
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