1 2 3 Previous Next

Qlik Product Innovation

34 posts

This month, we’re excited to announce a new customization feature for Qlik Sense Cloud Business users! You can now upload your own custom themes to your Qlik Sense Cloud Business workspace, and create and publish apps that reflect your own specific style requirements. For example, you can now apply a preferred color palette or your brand guidelines to apps.

 

To create your own custom theme, you’ll need to compile a compressed zip folder with three key components:

  • A definition (QEXT) file
  • A main JSON file
  • Any additional assets that support the theme as needed (i.e. CSS files)

 

Once you’ve created the folder, you can upload it to the new Themes section in the settings area of Qlik Sense Cloud Business. Once uploaded, the theme will then appear in the App Theme drop-down in the App Options menu. Don’t forget, you can also reference this list to apply any of the default themes available to all Qlik Sense Cloud users – Sense Classic, Sense Breeze, and Sense Focus.

AddTheme.gif

 

Curious about what Google and Super Mario themes look like in Qlik Sense? Watch the video below to see how Mike Tarallo uses those examples to highlight everything you need to know to set up custom themes.

We’ve attached the Google theme files Mike uses in his demonstration to this blog so that you can try uploading custom themes on your own.

 

Finally, check out some of the great resources below – including our online help documentation and other Qlik Community blogs – for more details on how to create custom themes.


 

Can't see the video? YouTube blocked by your region or organization? Download the .mp4 attached to watch on your computer or mobile device.

Since we launched Qlik GeoAnalytics about a year ago, there has been great interest among both Qlik Sense and QlikView users in adding mapping and geo-analysis capabilities to their Qlik environment.  Now we are making it even easier.  Starting with Qlik Sense April 2018, we updated the mapping capabilities within Qlik Sense to be based on Qlik GeoAnalytics technology.

 

This new map chart object makes it easy to add maps to your app.  Location related names such as countries, counties, provinces, regions, cities, airports, and zip codes now utilize a dynamic location name lookup service to automatically define and visualize geo data.

 

This new capability is available to all Qlik Sense users, whether they are using Desktop, Enterprise or Cloud.  Additional Qlik GeoAnalytics features such as multiple layers, layer control, zoom levels, labels, and multiple point symbols are also included.  And if you have maps in your existing apps, they will be seamlessly migrated to the new map object.

 

Points and area layers are available in this initial release.  Additional layers and more capabilities are planned for future releases. Note that all geo-analysis calculations, such as drive-times, travel areas, binning, clustering or intersections, still require a different license.

 

If you haven’t seen it yet, some of these new mapping capabilities can be found in the video - What’s New in Qlik Sense April 2018.  Click on the image below to watch the video.

 

2018-05-09 12_06_00-Clipboard.png

 

As seen in the Product Keynote during Qonnections, the Qlik Sense April 2018 release has exciting new improvements to Qlik Sense Enterprise, Qlik Sense Cloud, Qlik DataMarket, and Qlik Nprinting!

   

As part of these improvements, the release offers Accelerated Self-Service, which is a collection of features powered by the new Qlik Cognitive Engine, aimed at streamlining and enhancing the creation experience from data to insights. Now providing a new augmented experience in the first few minutes of analysis, including cognitive AI suggestions and redesigned workflows that facilitate and automate the data loading and visualization process. This includes smart capabilities around chart recommendations, and simplified workflows for loading data and building analytics.  Qlik now automatically understands what type of fields are being dragged onto the screen.  For example, if you drag on a measure, the values will be summed and displayed as a KPI; and if you add a dimension the visualization will automatically change to a recommended optimal chart based on the data within the added fields.  These new features allow users to quickly gain insights rather than building charts. The release also includes improvements to accessibility, along with the new capability for self-service publishing in the Qlik Sense Hub – all of which support our commitment to Accelerated Self-Service!

 

 

    WhatsNew_AprilSense.JPG

 

 

The April 2018 release also provides more customizations, like improvements to theming, layout options, along with grid size control and custom abbreviations. Several other enhancements have been made including a new add on product for geocoding and a new multi-layer map object based on the Qlik GeoAnalytics technology. This supports dynamic lookups and shapes, and includes more background maps and projections.

 

 

 

    MapObject.png

 

 

For the Qlik Sense Mobile app for iOS, we are expanding Enterprise Mobility Management (EMM) support, with AirWatch per-app VPN support. This allows enterprise administrators to manage Qlik Sense Mobile deployments and secure network traffic through corporate firewalls. 

   

In the Qlik NPrinting April 2018 release we have added SAML authentication, and have made improvements to the stability of Qlik Sense chart rendering. Further improvements have been made to the Qlik NPrinting filtering system for enhanced error monitoring capabilities.

   

For Qlik Sense Cloud, we have added the same capabilities as detailed above around accelerated self-service, improved customizations and multi-layer map objects.  Additionally, we have made UI and navigation enhancements to the Cloud hub which makes it even easier to collaborate and share, as well as adding the ability to download charts as images or PDFs and export data from charts.  We have expanded our data connectivity capabilities, including connectors for Oracle and PostgreSQL and a variety of new web/cloud connectors bringing us to over 31 Qlik Web Connectors! 

   

Lastly, in Qlik DataMarket, we have delivered two additional healthcare data packages, including Accountable Care Organizations (ACO’s) and Social Determinants of Health. 

 

For more information on the April 2018 release, head to Qlik’s “What’s new” page!

 

 

 

If you already logged into Qlik Sense Cloud today, you may have noticed things look a little different. Do not panic – all of your content and group configuration remains the same. The new look simply makes it even easier to collaborate and share – two of the things users enjoy most about Qlik Sense Cloud.

 

Qlik Sense Cloud Basic and Qlik Sense Cloud Business enable individuals, groups, and teams to work together and share data, app, and insights. As more users share their personal content and become owners of and contributors to multiple work groups, they have many different content streams to monitor and manage. We designed this “context switch” to help you easily navigate all of your content and understand where you are at all times.

 

Use the new drop down menu in the top left corner to select which space you’d like to access – your Qlik Sense Cloud Basic personal space, or a Qlik Sense Cloud Business group space. This single feature will help you:

  • Create more distinction between personal streams and workspace streams
  • Easily access your personal space, and personal streams others are sharing with you
  • Access workspaces you manage, and Qlik Sense Cloud Business streams you can view

 

Watch Mike Tarallo's short video to learn how to navigate the new layout and get oriented in no time:

 

Additional Connectivity Updates

We’ve also added several new data connectors in the last couple of weeks, so you have additional options for connecting to on-premise and cloud data sources. The new connectors include: Oracle, PostGreSQL, Google Big Query, Klout, GitHub, Google Search Console, Google AdSense,  and Google Calendar.

 

Interested in learning more? Register here to watch an on-demand webinar and see an in-depth demo of Qlik Sense Cloud Business.

You may not be aware that Qlik has a long-standing integration and partnership with SAP. Qlik have delivered and maintained connectivity to SAP ERP and BW for in excess of 10 years.

 

As SAP have evolved, Qlik has evolved, and maintained our position in providing connectivity as far back as R/3 to ECC and now to S4/HANA. In just the last 12 months we have expanded our SAP connectivity for Qlik Sense to also include the Extractor connector, the Bapi Connector and a brand new InfoProvider connector, which takes many of the complexities away from what was once a long and complex task of connecting directly to an Info Cube or MultiProvider. Today, we offer SAP Connectors that work directly with:

  • SAP Reports
  • SAP Queries
  • SAP Extractors
  • BEx Queries
  • DSO/ODS Objects
  • BAPI
  • SQL
  • OLAP
  • Multi-providers
  • Infocubes
  • Relational tables
  • HANA views
  • CDS views

We continue to invest more than ever in our SAP connectivity, with a vision to bring governed and easy to use connectivity to as many SAP objects and platforms as possible. And working directly with SAP and certifying our connectors ensures that we go through a rigorous certification process with SAP, and that data access through the SAP application layer retains all security that is managed through the SAP system.

SAP certification logos.png

Outside of ERP and BW connectivity, the SAP in Memory platform HANA is a fundamental part of our development and testing cycle. We have made enhancements to the core of our products, the Qlik Associative engine, to not only support connectivity to HANA views, including Attribute, Analytical, Calculation and Source tables, but to be able to do that through Single Sign On. This will allow one to retain security defined within HANA itself through a shared connection within Qlik Sense.

 

Our vision is to continue to provide simple access to what can be complex data sources and structures in a self-service capacity. Maximizing your SAP investment should be as simple as connecting to any other data source.

Task chaining is here! We are delighted to announce that one of the most requested features for Qlik NPrinting is now available with our February 2018 release.

 

If you thought that Qlik NPrinting 17 triggers were only time-based and prevented you from creating event-based dependencies on other Qlik tasks, (such as app and data reloads) then think again. This functionality is now available out-of-the-box using the Qlik NPrinting APIs and a Qlik load script!

 

You can now seamlessly run tasks that represent the typical workflow for a Qlik NPrinting report. Using the publicly available APIs, you can reload Qlik NPrinting connection metadata, update user information and run a publish task, all following a Qlik data and/or app reload.

 

You can also institute a poling mechanism to ensure that one task is complete before starting a subsequent one.

 

The technical details and examples can be found here: https://community.qlik.com/thread/292037 (even though the example uses Qlik Sense, this can be done just the same in a QlikView load script).

 

Please note that this functionality was made possible by the resolution of a bug related to the Qlik REST connector. You will need the REST connector v1.3 which is part of the February 2018 release of Qlik Sense, or it can be downloaded separately and copied over the old REST connector.

 

Our long-term vision for reporting involves exposing the Qlik NPrinting tasks in the QMC, however this is a first major step toward integrated scheduling

If you recently noticed the ability to add extra streams and larger apps to Qlik Sense Cloud Business – don’t worry, you didn’t buy more by accident. The changes are part of our ongoing effort to pass more value on to you.

 

Here’s what you need to know about the three newest updates to Qlik Sense Cloud Business:


Price change: As of February 19, we’ve reduced the price of Qlik Sense Cloud Business from $25/user per month to $15/user per month, billed annually.* If you haven’t tried Qlik Sense Cloud Business yet, take advantage of the reduced price today and get started with a 30-day free trial.

 

Increase in Maximum App Size: the maximum app size in Qlik Sense Cloud Business is now 250 MB, up from 150 MB. Build larger apps, and leverage the growing list of data connectors (including Dropbox, Amazon Redshift, and soon, PostgreSQL and Oracle) available in Qlik Sense Cloud Business. Ultimately, bring even more of your data and analytics to your workspace.


Increase in Content Streams: Qlik Sense Cloud Business subscriptions now include five content sharing streams instead of three. Add more team members - and/or more content - and create and maintain additional governed content areas

 

You may be wondering, “Why is the price Qlik Sense Cloud Business significantly reduced, while at the same time it keeps getting better, with more connectivity, streams, storage, and other features?

 

Simply put, Qlik has become much more efficient at running Qlik Sense Cloud.  Qlik invested heavily in a micro-services architecture as the backbone of Qlik Sense Cloud and the hybrid cloud features available soon for Qlik Sense Enterprise. Our unique approach enables Qlik Sense Cloud to scale efficiently and we felt it was only right to pass the savings onto you.

 

We’re always working to ensure groups and teams from any-sized enterprise gain immense value from Qlik. We’ve already had a lot of updates to Qlik Sense Cloud this year – stay tuned for Qlik Sense Cloud’s exciting new look!

 

 

*$18/user per month on a month-to-month contract.

Qlik DataMarket now offers 2 new topical data packages. The CMS Cost Reports and the Consumer Assessment of Healthcare Providers and Systems.

 

These latest additions to the Qlik DataMarket product offering allow customers to analyze and understand how payments for the same procedure can vary across specialties and regions. They also provide insights into how consumers view their experiences while undergoing various procedures.The two new products are based off the wealth of data that the Center for Medicare and Medicaid Services (CMS) makes available about healthcare providers in the United States.

 

CMS Cost Reports

ScreenShot_CMS Cost Report - front page.png

 

Healthcare providers participating in the Medicare program are obligated to report on various parts of their operation; facility characteristics, utilization, costs and charges by cost center and so on. Qlik DataMarket now wraps these Hospital Cost Reports up in data models, and alongside these models, our customers get a sample application that highlights some of the data available. This allows the users to better understand the various potential uses of the data.

 

Among the various questions that can be teased out of the CMS Cost Reports data are:

 

  1. What are the total submitted charges for any given procedure in the US, and what is the average submitted charge per state or city?
  2. If the same kind of procedure is performed by different specialties, then how does the average payment amount from Medicare differ by specialty?
  3. How much does a standardized visit to a doctor cost, based on location? How big a part of that does the Medicare/Medicaid program cover?
  4. How much does the healthcare provider need to write off from his charges to remain in the Medicare program? What is the reduction in the number of procedures needed to remain at the same level of revenue?
  5. What is the number of beneficiaries per procedure or volume of procedures by specialty and location?

 

This is just a sample of the questions and insights delivered by CMS Cost Reports package.

 

Consumer Assessment of Healthcare Providers and Systems


ScreenShot_State and National Level COmparion of HCAHS Survey Results.png

 

 

The Consumer Assessment of Healthcare Providers and Systems (CAHPS) is a series of patient surveys where consumers of healthcare services rate the quality of service provided. The Agency for Healthcare Research and Quality governs CAHPS.

 

Among the topics covered in CAHPS are Hospitalization are: star ratings, communication ratings, environment, effectiveness of care, willingness to recommend, and other quality metrics that impact the experience from admission to discharge.

 

The data applies to:

  1. Nearly 7,000 Dialysis facilities with about 119,000 dialysis stations.
  2. Over 10,000 Home Healthcare Agencies
  3. 4,600 Hospitals

 

All in all, the data comes packaged up in 13 data files and 3 sample applications that provide insights into what questions and answers can be teased out of the data.

 

Typically this data is hard to find and difficult to integrate into existing data models. However, we curate the data for you and make sure that all diseases and treatments, geo-dimensions and healthcare providers have been identified and that the appropriate unique identifiers have been associated with each. For example, each type of procedure is coded with the HCSPC code (Healthcare Common Procedure Coding System).

 

To get you started quickly, reach out to your account manager for a demonstration of the applications. You will be able to rapidly integrate your own data with these applications for unique insights.

 

Learn more about Qlik DataMarket

Be sure to follow along Qlik Sense Cloud updates through March. We will roll out a lot of new updates to Qlik Sense Cloud Business that you’ve been waiting for (and some surprises, which we’re pretty sure you’ll enjoy!). Here is what’s new today:

 

Export to Excel

Qlik Sense Cloud Business group members with view-only access to apps now have the ability to export visualization data to Excel. This creates more flexibility for group owners who want to grant group members access to some data, but all of the content in the workspace.

 

Excel 1.png  Excel 2.png

 

Additional Connectors

New web connectors are now available via the data load editor:

Additional web connectors and on-premise connectivity (PostgreSQL and Oracle) will be available soon. You’ll also notice that we’ve updated the layout the data load editor screen, to make it easier to sort through the expanding list of connectivity options.

 

Qlik Sense February Release Features

Use Qlik Sense Cloud to get a preview of some of the new Qlik Sense February release features that will be available in Qlik Sense Enterprise this month:

  • Visual Data Prep Improvements: these enhancements provide the ability to gain visual guidance by hovering over fields. An association recommendation panel guides users through the possible associations between tables and facilitates experimentation before committing to data model changes.
  • New Built-in Theme: check out "Sense Breeze", a colorful new out-of-the-box style choice in the app options menu.
  • Web connector updates: the web file connector now includes a secure way for scripts to dynamically generate URLs before retrieving data using the web file connector, opening up a range of new possibilities for querying web-hosted files.

To learn more about the Qlik Sense February release, check out this video.

The new 2018 Qlik Statement of Direction is now available on our website. The Qlik Statement of Direction provides a comprehensive overview of our company, products, and vision for the future.

 

2018-01-31 12_10_28-Document1 [Compatibility Mode] - Word.png

 

It includes:

  • An outline of our future strategy and innovation agenda around 3 main areas - data, platform and analytics
  • An introduction to our company and overview of our key differentiators in the market
  • A comprehensive overview of our current product portfolio, including Qlik Sense, QlikView, the Qlik Analytics Platform, and our add-on products
  • A detailed look at our future roadmap and planned investments in our products, organized by innovation area
  • A reinforcement of our commitment to our customers and partners

 

This document is freely available for download at https://www.qlik.com/us/qlik-statement-of-direction for anyone that wants an overview of our company and products or a look into our roadmap.

 

 

Thanks!

Happy New Year! We’re excited (and hope you are, also) to ring in 2018 with the much-anticipated Dropbox connector now live in Qlik Sense Cloud Business. Our newest connector gives Qlik Sense Cloud Business users more variety and flexibility in how and where they store and refresh data.

 

Some how-to’s:

  • Access the connector via the data manager or data load editor. Note that within the data load editor, it falls under “Web Storage Provider.”
  • Authenticate like many of the other connectors, using token authentication. If you are already signed in to your Dropbox account when you authenticate, this process will be even easier.

 

And some highlights:

  • After you authenticate, you will be able to view the folder and file structure you have set up in your Dropbox account and sort by file type.
  • You can create apps directly from data files, including QVDs, that remain stored in or linked to your Dropbox account – you no longer have to attach or upload those files.
  • You can upload and update files manually to Dropbox or set up an automated data file upload when data is added or changed. Then use Qlik Sense Cloud Business’s scheduled data refresh to update any app using that data (see Mike Tarallo’s video on how to do this here). These steps automate and streamline the entire data update process.

 

Ready to get started? Use the attached sample data file to test out connectivity with your Dropbox account.

 

Dropbox Picture 3.png

Additional Connectivity

If you missed our November blog post (which you easily may have, because it was accidentally posted to the wrong location), scroll down and read about Amazon RedShift.

 

For our marketing users in particular, we have two new web connectors for sentiment analysis tools – Repustate and Sentiment140. Now you can have more of your social analytics data in one place, and take a deeper dive into text and content analysis.


Coming Soon

Last year was busy as we grew our Qlik Sense Cloud Business community, continuously added new features, and listened to all of your valuable feedback. With that feedback in mind, this year we plan to broaden the capabilities and options in Qlik Sense Cloud to support more use cases and help you find insights faster. Our focus on connectivity will continue, particularly around on-premises connectivity. We’re also working on a wide variety of usability enhancements, new feature additions, and onboarding support and resources - plus the February release features - that we look forward to showing you soon!

2017 was a very busy year for Qlik NPrinting, from the standpoint of improving stability and performance, filling gaps from NPrinting 16, and extending the product with a platform-based approach in mind.

 

Let’s start in April with Qlik NPrinting 17.3.1. This service release contained a significant amount of bug fixes, and on top of the improvements made in version 17.3 in February, represented the first truly stable version of NPrinting. We received positive feedback from the field and at Qonnections shortly after this version was released. During an open discussion at a customer presentation at Qonnections, several customers who were unsuccessful with previous versions voiced that they had just upgraded to this version and were able to get their environments running without issue.

 

While we continue to focus on product stability and quality, crossing this proverbial tipping point allowed us to turn our attention to highly requested gap features and functionality, and building out enterprise reporting APIs.

 

The June 2017 release included a task execution monitoring page where from within the Qlik NPrinting web console, task status, percentage completion, and a snippet of the log file can be viewed. There are plans to increase the amount of data available in the monitoring view in future releases.

 

We also introduced APIs aimed at three types of reporting activities: task chaining, user management, and On-Demand reporting for Qlik Sense (including user selections as report filters). In 2018, we will continue to enhance our APIs to be more robust.

 

Additional highlights included support for Qlik Sense third party extensions, a connection verification button and making metadata reload a schedulable task.

 

In September, we filled the long-requested gap of report cycling, which allows for an easy way to loop through dimension(s) values and produce unique report files for them.

 

Another highly requested capability that was part of this release is the ability to migrate reports between Qlik NPrinting environments. The import/export process includes a check on the connection(s) used for the report template, as well as any filters that are applied to the report. It is on our roadmap to support migration of more Qlik NPrinting entities. Note that you can effectively “clone” a report by exporting it and then re-importing it into the same environment.

 

And in our final release of the year (November 2017), another key gap was filled with embedded reports. HTML reports or reports rendered in image formats can be embedded directly in the body of an email message.

 

Last but not least, we added new image quality settings for reports. There are now three options to choose from when adding a report to a publish task: normal (96 dpi), high (192 dpi), and very high (384 dpi). While these settings impact both QlikView and Qlik Sense images, the overall quality improvement is much more evident with Sense.

 

At this time, we also have a technical preview of our February 2018 release available on Qlik Community. This release includes support for JWT authentication, as well as DMS authorization for QlikView. Please see the technical preview help site for more information.

 

We are looking forward to 2018 being a great year for Qlik NPrinting and its users!

(Originally posted on 11/29 on the Qlik Sense Cloud blog, so in case you missed the updates, read on!)


Qlik Sense November 2017 Release

Our Qlik Sense November 2017 release features are available in Qlik Sense Cloud. Qlik Sense Cloud Basic and Qlik Sense Cloud Business users now have access to the newest data prep, visualization, and usability improvements, including:

  • Improvements to existing chart types:
    • Tables – scroll sideways
    • Box Plot – color by expression
    • Distribution Plot – color by expression, control bubble size, and add jitter (to keep dots from overlapping)
    • Combo Chart – display value labels
  • Ongoing Visual Data Prep Enhancements
    • UI based in-line data table
    • Data Transformation Lineage
  • Refresh and add data available from analysis edit mode
  • Dynamic Sheet Names – utilize an expression in the name of a sheet
  • Navigation Improvements using Keyboard – use the tab key to move around the screen

Mike Tarallo shows off all of these new features in his recent design blog post.


New Connectivity – Amazon Redshift

We’re excited to announce that Amazon Redshift is the newest addition to our expanding list of connectivity options for Qlik Sense Cloud Business users. Now you can easily connect to data stored in your Amazon Redshift database by creating a new connection in Add Data or the Data Load Editor. Visit our help section to learn more about how to set up the connection.


The full list of connectivity options in Qlik Sense Cloud Business now includes:

  • General Connectivity: upload or attach files; connect to web files; REST, Microsoft SQL Server, and Amazon Redshift
  • CRM Connectivity: Salesforce, SugarCRM, and Microsoft Dynamics
  • Other Cloud applications: Bitly, Facebook, Google Analytics, Google Adwords, MailChimp, Slack, SurveyMonkey, Twitter, and YouTube


Coming Soon

We’re close to releasing our Dropbox connector for Qlik Sense Cloud Business and excited to add another flexible connectivity option for users. For a preview of how to use the Dropbox connector, check out Mike Tarallo’s recent design blog and video below about how to refresh file-based data stored in Dropbox.

 


More Qlik Sense Cloud highlights:

    Hear about the latest trends in cloud BI! Cindi Howson of featured analyst firm Gartner explains all the factors you need to know about cloud BI. Plus, Anthony Deighton, Qlik's Chief Technology Officer and Senior Vice President, Products, shares the latest on Qlik's unique hybrid cloud solution.

Some of you may have already tried the animator tool that comes with Qlik GeoAnalytics.  The extension allows you to easily animate data in a map.  The algorithm for the animator is pretty straight-forward – charts and tables are visually updated as the animator progresses through each data point within a selected dimension.  You have the option to aggregate the data while the Animator progresses.  You can also animate in a continuous loop.

 

For example, you could animate the appearance of new stores on a map according to their opening date. Assuming there was a dimension like StoreOpenDate, new store locations would appear on a map as the Animator steps through each date in the StoreOpenDate dimension.

 

The Animator is already available in Qlik GeoAnalytics for Qlik Sense.  With the release of Qlik GeoAnalytics November 2017, the animator tool is also now available in Qlik GeoAnalytics for QlikView.

 

But did you know that the Qlik GeoAnalytics Animator can be used with any chart, not just a map?  Bar charts, histograms and tree maps can come to life.  And the dimension used by the Animator doesn’t have to be a time-based variable. So in addition to months, dates or hours, you could animate according to season, product code, account type, age span, etc.

 

Tip – If you want to minimize the visual jumpiness of a chart as the animation progresses, define the min and max of the Y axis to set values instead of Auto Range.

 

The tool is fairly simple to use.  Here’s a short example:

 

More details about the Qlik GeoAnalytics Animator can be found in the Qlik online help here

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.