Qlik Community

Qlik Product Innovation Blog

Learn about what's new across all of the products in our growing Qlik product portfolio.

qlikviewupdates
New Contributor III

QlikView November 2017 now available

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
Honored Contributor II

what's difference with Qlikview November 2017 ?

0 Likes
72 Views
mattrai24
New Contributor III

The Patch 12.2 is called November.

It's the same version.

0 Likes
72 Views
mattrai24
New Contributor III

The version is QlikView November2017 the patch is 12.2.

0 Likes
72 Views
aditya_christia
New Contributor

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
72 Views
agigliotti
Honored Contributor II

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
72 Views
i_shamaev
New Contributor II

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
72 Views
aditya_christia
New Contributor

i re-saved existing application..

0 Likes
72 Views
i_shamaev
New Contributor II

Can you send your non-working Set Analysis?

0 Likes
72 Views
i_shamaev
New Contributor II

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
72 Views
lwt
Contributor III

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
72 Views
i_shamaev
New Contributor II

We have returned to the migration from QV11 to QV12. We reproduced the error. The error has not yet been resolved. The sequence of our actions:

1. Have made an upgrade to QlikView 12 SR1 (without Settings.ini, create new Settings.ini)

2. Everything worked well.

3. Added settings from the old Settings.ini file of QV11

StandardReload=1

ConcurTimeoutSec=1800

xqn=-1

xqu=-1

xqs=-1

xqd=-1

EnableAuditLog=0

QvMetaAutoLoad=0

QvMetaAccessControl=0

4. Chart began to work incorrectly. After removing rows from Settings.ini still did not work

The Expression is

sum({<[Date]={'$(vVariableDate)'},[Measures1 %]={'<=70'},[Measures2]={'<100000'},WarehouseName={$(vVariableWarehouse)},OfficeName={'Name Example'}>}[quantity])

vVariableDate

04.04.2018

vVariableWarehouse

'Warehouse 1*','Warehouse 3*'

5. Upgrade to QV12 SR3. Does not work

0 Likes
72 Views
i_shamaev
New Contributor II

I tried to apply the parameters in the Settings.ini:

EnableBnfReload = 0

EnableSingleQuoteExactSearch=1

And in Script of Document:

///$sqs old

///$bnf off

Does not work

0 Likes
72 Views
i_shamaev
New Contributor II

If delete the ALL SET ANALYSIS then the chart works

0 Likes
72 Views
i_shamaev
New Contributor II

Before data reloading chart works.

After data reloading, the chart does not work.

0 Likes
72 Views
i_shamaev
New Contributor II

I found the cause of the error. Interim calculations (ETL) have formed a date in the format 'DD.MM.YY'. Data was loaded into QlikView Document Model in the format 'DD.MM.YY'. But in the SET ANALYSIS the format was 'DD.MM.YYYY'. The upgrade affected the ETL process, not the work of the models.

Perhaps our problem is solved.

0 Likes
72 Views