Qlik Community

Ask a Question

Qlik Design Blog

All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
etk
Employee
Employee

Yesterday we announced QlikView 11.2. The main new feature in this release is QlikView Direct Discovery. With this exciting feature, QlikView does not require loading all data into the QlikView in-memory engine anymore. QlikView Direct Discovery is a hybrid approach that leverages both in-memory data and data that is dynamically queried from an external source.

Capture.JPG

Some of the main benefits of QlikView Direct Discovery are:

  • Consolidate relevant data from multiple sources, including Big Data repositories

In addition to the current decision support environments like EDW, data marts and operational data stores, organizations are now also considering the big data storage environments, such as Hadoop, BigQuery or Teradata etc. The challenge is enabling business users to analyze data from all of these data sources in the same analytics application. QlikView Direct Discovery offers a hybrid approach solving this challenge. It allows users to seamlessly run queries on the big data stores while they do discoveries on the data extracted from their ERP systems, data marts, EDW or even from their excel files into memory.

  • Maintain associations among all the data, regardless of where it is located

The level of details that is stored in the big data stores is usually very granular. Business users need an easier navigation means in this bulk of data. QlikView Direct Discovery leverages associations in the data, making extremely large datasets manageable.

For example, a policy analyst who uses a QlikView app to analyze regional loss and revenue information on a daily basis, would know the region names, but he would not have any clues on the specific policy numbers for these regions. With Direct Discovery, he can select the regional info, as he would do every day, and QlikView would automatically associate and query the billions of policy-level information on the big data store and display the query results with the in-memory metrics on the same QlikView app for the selected region.

  • Access Big Data without complex data modeling or programming

It is very easy to use Direct Discovery feature on a QlikView application. The only thing that is changed is to use “DIRECT SELECT” on the load script instead of using “SQL SELECT”. This new keyword would indicate QlikView that the data source is a direct discovery source. In this case, QlikView would only load the field names and will bring the data to the user interface when a direct discovery field is used on a QlikView chart. More information on the technical aspect of this feature can be found in this technical addendum paper. A how-to video is also available here.

Please note that QlikView 11.2 is a new release of QlikView, with one new feature, QlikView Direct Discovery. Please read the QlikView 11.2 Release Note document that is available on the download site before upgrading to QlikView 11.2 to learn more about the release and some of the bug fixes with this release. With this release, the QlikView 11 branch will be stopped and new service releases will be  made for QlikView 11.2 instead. For more information on this subject, please contact the QlikTech Support team.

Since we announced this new feature in October, we have seen great excitement in our customer and partner community as they see the potential of QlikView 11.2 enabling Business Discovery with Big Data, without any data size limitations. QlikView 11.2 is now available on our download site if you also would like to expand your business discovery capabilities on the data sets that were previously used separately, or not used, because of their bulk and the development effort required!

16 Comments
perumal_41
Partner
Partner

Hi,

Any update from QV 11 SR 2 to QV 11.20 in Server side.

Regards

Perumal A

0 Likes
1,439 Views
etk
Employee
Employee

Hi-

Please read the QV11.2 Release Note document (available on the download site) for further details on how to upgrade. Also, this technical blog provides info on this subject;

http://community.qlik.com/blogs/qlikviewdesignblog/2012/12/13/qlikview-112-is-available

Thanks a lot!

Elif.

0 Likes
1,439 Views
pedromsouza
Creator
Creator

In future versions will it be possible to use more thant just one direct table?

1,439 Views
pauljohansson
Creator III
Creator III

Hi,

The "How-to" link is not working, it throws back "Unauthorized"

br

Paul

0 Likes
1,439 Views
Not applicable

Hi Elif,

I'm new to QV development and would like to know if you have to always add or use vb or java scripting proggramming when developing BI solutions in QV?

0 Likes
1,439 Views
Not applicable

I don't see any release notes on the download page for Server 11.20. Only

- Documentation & Tutorial

- Installation Program

Where can I get the release notes?

0 Likes
1,439 Views