We are happy to announce that QlikView November 2017 (version 12.2) is now available on our customer download site.  It includes a number of new features and enhancements for analytics, usability, and management / administration.


Advanced Analytics Integration


Many organizations are making significant investments in data science and advanced analytics, in areas such as sales forecasting, fraud detection, inventory optimization, market basket analysis, pricing optimization, and more. However, a large percentage of these companies are not seeing the value of these investments realized widely across their organizations.

Advanced analytics integration, now available in QlikView, allows users to interact with and explore advanced calculations from third-party engines such as R, Python, Matlab, etc. As users make selections, data is sent from the Qlik engine to third party tools, calculations are made in realtime, and the results are returned and immediately visualized for the user. This allows people to ask their own questions and spot insights that would have been missed with query-based or batch approaches, greatly broadening the reach and value of advanced analytics investments.

2017-11-16 10_23_18-QlikView 12.2 Blog - Draft for Review.docx - Word.pngQlik offers open, server-side extension APIs that allow connectors to be built for any external engines, supporting many types of business specific use cases. For R and Python, Qlik has also delivered open-source connectors, which are now supported by the community. This aligns with how R and Python themselves are supported (these are both open source tools). We expect the community to enhance these and contribute other connectors for additional integrations.


For more information, check out our community site on advanced analytics integration.


Web client improvements


Qlik has made significant investments in the QlikView web (AJAX) client, to ensure feature parity between it and the Internet Explorer Plugin (which is not being developed further). In this release, many new usability improvements have been added to the web client, including:

  • Detach – A Detach option is now found in the right-click menu for any chart object. When a chart is detached, subsequent selections will not be applied to the object until it is re-attached, allowing users to exclude and compare charts against the overall selection state.
  • Set reference – A Set Reference option is now found in the right-click menu for Bar, Line, Combo, Gauge and Scatter charts. When Set Reference is selected for a chart object, the current data display of that chart is permanently shown as a dimmed view alongside the subset of data visualized after a selection is made, enhancing comparative analysis capabilities.
  • Switch language - Users can now choose the UI language they prefer in the profile settings in AccessPoint.
  • The copy single column selection option is now available for List Boxes.
  • Copy Cell functionality is now available in the List box, Straight Table, and Pivot Table.


Management and other improvements


A number of additional improvements have been made to QlikView, around management and functionality, including:

On-Demand App Generation enhancements – New capabilities have been added such as an option for developers to include the app navigation link UI into a web mash-up, and the ability to ensure that generated apps utilize the same SSO for authentication back to the data system.

  • Shared File Management improvements – A new structure and transaction handling for shared files has been implemented, significantly reducing the risk of corrupted files in high-traffic scenarios. Additionally, a new method of cleaning shared files to remove inactive users has been implemented, which can greatly improve server performance.
  • KML support - QlikView can now read KML files for use in a map visualizations. The KML file can represent either area data, such as countries or regions, or point data such as cities or places.
  • Export to XLSX (vs. XLS) – XLSX is now the default export format for Excel files, replacing XLS.
  • Update to quote interpretation in set analysis – An update has been made to the Qlik engine which changes the way that quotes are interpreted in set analysis expressions. Single-quotes are now utilized for literal interpretation of the items enclosed within them, and double quotes are evaluated and allow for the use of such things as wildcards.
    • This change ensures that set analysis interprets quotes in the same way as other areas of the engine, and is consistent with our documentation and best practices.
    • Apps created in prior versions will not need to be updated, as the system will respect the old method for these apps. However, customers may opt to force all apps to respect the new rules.
    • This change allows for the ability to support case sensitive search strings in set analysis.
  • A new BNF script reload mode has been introduced, which uses the same syntax checks as those in the script editor.


Value Added Products


In addition to core QlikView capabilities, there are several new improvements in this release to value added products that work with QlikView, including:

  • Qlik NPrinting reports can now be directly embedded in emails, eliminating the requirement for an attachment, which provides a greatly improved experience on mobile devices.
  • Qlik NPrinting reports now have configurable output resolution, allowing fore more granular control and helping with file size.
  • Map Animations in Qlik GeoAnalytics now work in QlikView allowing visualization of changes over time.
  • Four new healthcare data packages are available in Qlik DataMarket.