Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
QlikViewUpdates
Employee
Employee

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.
15 Comments
agigliotti
Partner - Champion
Partner - Champion

what's difference with Qlikview November 2017 ?

0 Likes
2,277 Views
MattRai21
Partner - Contributor III
Partner - Contributor III

The Patch 12.2 is called November.

It's the same version.

0 Likes
2,277 Views
MattRai21
Partner - Contributor III
Partner - Contributor III

The version is QlikView November2017 the patch is 12.2.

0 Likes
2,277 Views
aditya_christia
Contributor II
Contributor II

be careful for  this update, if you're using complex set analysis with variable, it would be messed up.

i already upgrade to 12.2, and back to 12.1

0 Likes
2,277 Views
agigliotti
Partner - Champion
Partner - Champion

I discovered a bug regarding direct discovery feature using ajax client.

take a look at Qlikview November 2017 - error with direct query in QvAjax.js using web browser

0 Likes
2,277 Views
i_shamaev
Creator
Creator

Christian, Hello!

Please send a non-working example of your Set Analysis.

Did you create a new application? Or re-saved the old application?

0 Likes
2,277 Views
aditya_christia
Contributor II
Contributor II

i re-saved existing application..

0 Likes
2,128 Views
i_shamaev
Creator
Creator

Can you send your non-working Set Analysis?

0 Likes
2,128 Views
i_shamaev
Creator
Creator

If you want to update from QlikView 11 to QlikView 12, I advise you to save "C:\ProgramData\QlikTech\ManagementService". We had to roll back (downgrade) to the previous version (QlikView 11). Service "ManagementService" did not start. This folder stores the QMC Task schedule.

Some of our charts do not work because of the new Set Analysis Syntax. Parameter "EnableSingleQuoteExactSearch=1" and "EnableSingleQuoteExactSearch=0" did not help.

0 Likes
2,128 Views
Lars_Wahlstedt
Employee
Employee

Hi Ivan,

old documents should not be affected by the change and if you want to enforce the new or old behavior in a document you can add the below setting as one of the first lines in the script:

///$sqs new Forces the document to adopt the new behavior.

///$sqs old Forces the document to adopt the old behavior.

0 Likes
2,128 Views