Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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
i_shamaev
Creator
Creator

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
1,325 Views
i_shamaev
Creator
Creator

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
1,325 Views
i_shamaev
Creator
Creator

If delete the ALL SET ANALYSIS then the chart works

0 Likes
1,230 Views
i_shamaev
Creator
Creator

Before data reloading chart works.

After data reloading, the chart does not work.

0 Likes
1,230 Views
i_shamaev
Creator
Creator

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
1,230 Views