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"
12 Comments