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.

Qlik Sense November 2017 is now available from our Customer Download Site.    You can also try out many of the new capabilities in Qlik Sense Cloud where you can use Qlik Sense Cloud Basic for free or try Qlik Sense Cloud Business with a free 30 day trial.



Watch this brief highlights video to learn more:



You will find many new features and capabilities in this release including:


For Business Users


    • Improvements to existing chart types
      • Tables - Ability to scroll sideways.
      • Box Plot - Ability to color by expression.
      • Distribution Plot – Ability to color by expression, control bubble size, and add jitter (to keep dots from overlapping).
      • Combo Chart - Ability to display value labels.
    • Navigation Improvements using Keyboard - Ability to use the tab key to move around the screen.


For App Builders

    • Dynamic Sheet Names - Ability to utilize an expression in the name of a sheet.
    • Ongoing Visual Data Prep Enhancements
      • UI based in-line data table
      • Data Transformation Lineage
    • Refresh and add data available from analysis edit mode - The ability to both refresh and add data from the UI under data icon in edit mode. This eliminates the need to switch over to the data manager in order to initiate these common tasks.
    • Control Calculation Condition Message - Ability to control the message that a user sees when a calculation condition hasn't been met.
    • Update to Quote Interpretation in Set Analysis
      • 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.  However, some developers may have incorrectly utilized the single quote in places that should have double quotes and this enforcement of the intended use will cause issues in these cases.
      • 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 (using single quotes for literal values) allows for the ability to support case sensitive search strings in Set Analysis. 


For Administrators

    • SAML Single Sign-on Logout
    • Continued On Demand App Generation Enhancements


For Developers

    • Extension Certification Badging


  • Qlik Sense Cloud Specific Improvements
    • Utilize Linux as platform for presenting demo apps on Qlik Sense Cloud
    • Note: See connector updates under Qlik Connectors


Qlik Connectors

  • Additional Web Connectors – The following web connectors are now available in Qlik Sense Cloud Business and included in Qlik Sense Cloud Business trials and subscriptions: Facebook Insights, Microsoft Dynamics CRM, SugarCRM, Survey Monkey, MailChimp, Bit.ly, Slack. The Facebook Pages and Google Analytics also now include access to additional tables. These connectors are already available for Qlik Sense Enterprise.


  • Redshift, Google BigQuery and Dropbox- A new native connector for Redshift will be made available to Qlik Sense Cloud Business in November. Connectors for both Redshift and Google BigQuery will be released to Qlik Sense Enterprise in November also a Dropbox Connector will be made available to Qlik Sense Cloud Business and Enterprise.