UPDATE: Please note that the QlikView Excel Connector (the product referred to in this post) has now been replaced by
www.QVExcel.com.
More information can be found in
this post.
A short post today to mention a couple of enhancements made this week to the QlikView Excel Connector (beta).
The first, pictured here, is the addition of a new function which becomes available in Excel once the Add-in has been installed. This function (named 'qve', short for 'QlikView expression') allows any QlikView expression to be easily evaluated in a cell.
The function is recalculated every time the QlikView selections are updated providing a new way to get data from QlikView into your Excel sheets for further analysis or reporting. Of course the Add-in still also supports the orginal method of extracting data where the contents of entire QlikView table and chart controls (as well as textbox controls) can be extracted into cell ranges, but this new Excel function might now provide a more intuitive and flexible method in many cases.
The second update is a completely rewritten set of documentation which explains this new QlikView Expression function as well as the other features of the Add-in.
This latest 'beta 4' of the QlikView Excel Connector can be downloaded here.
