Last updated December 7, 2012.
QlikView 11 takes Business Discovery to a whole new level by enabling users to more easily collaborate with coworkers, supporting larger enterprise deployments through enhanced manageability, and delivering an enhanced mobile experience.
QlikView 11 makes it easier than ever before for business users to leverage three important sources of insight: data, people, and place.
- Improve data-driven decision making with improvements in several core areas: enterprise platform, rapid analytic app platform, and comparative analysis.
- Incorporate the perspectives, opinions, expertise, and observations of other people into decision making, with social Business Discovery
- Take advantage of being in a particular place at a particular time with mobile Business Discovery.
Table of Contents
General QlikView 11 Questions
How is QlikView 11 different from QlikView 10?
QlikView 11 brings new levels of capability and manageability to the QlikView Business Discovery platform. In this release, we focused our investments on five value propositions:
- Improve collaborative decision making with Social Business Discovery
- Gain new insights into opportunities and threats and relative business performance with comparative analysis
- Expand QlikView usage to additional devices, including smartphones, with mobile Business Discovery
- Enable a broad spectrum of users to jointly develop QlikView apps with QlikView’s rapid analytic app platform capabilities
- Improve the manageability and performance of QlikView with new enterprise platform capabilities.
For more info, see this video, "Introduction to QlikView 11":
Where can customers download QlikView 11?
Customers can get the latest release of QlikView, as well as the release notes, from our download site at http://www.qlikview.com/download.
What platforms does QlikView 11 support?
You can find full detail about supported platforms in the QlikView 11 and QlikView Expressor System Requirements data sheet (download here). Also see the
data sheet, "QlikView Governance Dashboard System Requirements."
What is the QlikView 11 service release timeframe?
- The initial release (IR) of QlikView 11 shipped on November 23, 2011 (see this post on the Technical Bulletin and this post on The QlikView Blog).
- We released an update to the IR (Update 1) on January 5, 2012 (see this post on the Technical Bulletin). This update contained a security enhancement and an updated end user license agreement (EULA).
- We shipped service release 1 (SR1) on April 12, 2012 (see this post on the Technical Bulletin and the release notes here).
- We released service release 2 (SR2) on September 28, 2012 (see this post on the Technical Bulletin).
- We released a beta version of QlikView 11.2 on November 7, 2012 (see this post on the QlikView Design Blog).
We will post info about upcoming service releases as it becomes available.
What are the differences among QlikView Server editions?
The differences are:
- QlikView Server Enterprise Edition (EE) is available for customers looking to support a large number of users and integrate into enterprise environments. It includes features such as:
- Unlimited documents
- Integration with third party security systems
- Server clustering
- Small Business Edition (SBE) is designed to be used in smaller deployments. It has the following limitations:
- For use only with Named and Document CALs
- Limited to 25 Named User CALs
- Limited to 100 Document CALs
- No support for additional servers
- Only supports Windows Active Directory to handle security and access control
- Information Access Server (IAS) is an edition of QlikView Server designed to power public Internet sites. This edition:
- Includes the add-on QlikView Real Time Server
- Is licensed for uncapped number of user but limited to one QlikView document
- Must be set to anonymous mode only and authentication must be off
- Requires that the QlikView server be on the public Internet and publicly accessible
- Requires that the URL for accessing the site powered by the QlikView Server be publicly accessible
- Requires that no QlikView client (e.g., QlikView Desktop, Internet Explorer plug-in, Ajax) can access the QlikView Server (all user interfaces must be built by the customer manually or with QlikView Workbench)
- QlikView Extranet Server (QES) is an edition of QlikView Server designed to extend QlikView functionality to external users via an extranet. QES:
- Requires authentication. Users must be external to the purchasing organization (customers, partners, etc.).
- Restricts server access to the Ajax client and mobile clients
- Provides the option to customize the QlikView application via the included QlikView Workbench
- Supports a maximum of 3 QlikView documents
- Supports session CALs and usage CALs only
Does Small Business Edition support DMZ (demilitarized zone) authorization?
Small Business Edition (SBE) only supports Windows-based authorization (Active Directory and Windows local users) and utilizes the web server to do the authentication against Windows. So if users are managed in Windows, SBE could be deployed in a DMZ. The SBE license, however, does not allow for external users. Customers that require access by external users should consider QlikView Extranet Server. QlikView Extranet Server allows access by external users and can be used with any user management system.
Is there a "What's New in QlikView 11" demo app?
Yes, you can find a "What's New in QlikView 11" demo app on the demo site here. You may need to click on the QlikView 11 banner to get to the QlikView 11-specific demos.
How does QlikView 11 address real-time data access?
As of QlikView 11 SR1, QlikView Server includes a real-time (dynamic update) component for accessing real-time data.
Does QlikView 11 support new chart types?
QlikView 11 does not include new chart types. Instead, we focused this release on making it easier for web developers to create QlikView extension objects, which enables customers to bring any visualization they want into QlikView and have it be fully interactive just like a native QlikView object.
In QlikView 11, are per-seat user licenses shared among multiple servers?
Just as with QlikView 10, if the servers are properly licensed and configured to cluster, then CALs are shared across the cluster nodes.
Does QlikView 11 add support for QlikView Desktop running on Macintosh?
QlikView Desktop does not provide direct support for the Mac platform. However, it works very well on Mac with a virtual machine.
Is QlikView 11 an in-place upgrade from earlier versions?
QlikView is an in-place upgrade from QlikView 9 and QlikView 10. But for upgrading from earlier versions, more work is required. You can find additional information here:
- The QlikView 11 release notes, which you get when you install the software.
- This thread on QlikCommunity
What additional resources are available about QlikView 11?
Please see these additional resources:
- Video: "Introduction to QlikView 11," October 19, 2011
- Video: "QlikView Product Tour," November 2011
- Data sheet: "What's New in QlikView 11," December 2012 (originally published October 2011)
- Data sheet: "Why Upgrade to QlikView 11," December 2012 (originally published October 2011)
- Data sheet: "The QlikView Business Discovery Platform" December 2012 (originally published October 2011)
- Demo app: "What's New in QlikView 11"
- The "QlikView Overview" section of the QlikView web site
- Business Discovery Manifesto
- On-demand webinar: "What's New in QlikView 11" November 2011
QlikView 11 Theme: Social Business Discovery
Decision making is inherently a collaborative activity. Social Business Discovery helps organizations leverage peoples’ shared insights in the decision-making process. With QlikView 11, business users can ask and answer streams of questions in formal or informal groups, in real time as well as asynchronously. Together, QlikView users collaborate to explore data and forge new paths to discovery and insight.
The new social Business Discovery capabilities in QlikView 11 build on existing collaboration functionality in QlikView, including collaboration objects, shared bookmarks, and Microsoft Office® integration.
Check out this video: "Social Business Discovery:"
General Social Business Discovery Questions
What is social Business Discovery?
In QlikTech’s vision of the future of Business Discovery, a social and collaborative experience is front and center. Using concepts from the consumer world, social Business Discovery enables business users to collaborate on discoveries and generate multiplicative insights. Users collaborate on creation of analytic apps and can define and answer their own questions in teams and groups. They communicate with each other in real time and asynchronously to collaboratively explore data, forge paths to discovery and insight, and arrive at decisions. They explore Business Discovery apps through a social lens to find the data and insights that are most relevant to them. With social Business Discovery, people can make unexpected discoveries that lead to better decisions and organizations can streamline the decision making process.
Social Business Discovery is for decision makers at all levels of an organization. QlikView’s social Business Discovery approach means workgroups and teams can collaborate on innovative decisions faster than ever by collectively exploring data, anywhere, anytime, on any device. And they can capture the conversation so there’s accountability and a decision history trail. QlikView also empowers IT managers and analysts. Unified management capabilities and the ability to more rapidly deliver relevant, segmented, live data and self-service analysis means they can serve the business like never before.
Does QlikView 11 provide support for analyzing social media data from sites like Facebook and Twitter?
QlikView 11 does not provide direct support for analyzing social media data. However, partners have built connectors and applications that do just this, using prior versions of QlikView. For example, Industrial CodeBox built QVSource, which is a set of QlikView API connectors to a variety of web services including Facebook, LinkedIn, and Twitter. And TIQ Solutions has built a sentiment analysis app called Sentival (check out the Sentival demo app).
How does QlikView integrate with other collaboration systems?
QlikView apps and objects can display alongside other related decision-making inputs such as documentation, traditional BI applications, or CRM or supply chain applications. We have customers using QlikView web parts for use with Microsoft SharePoint (download data sheet here), which enables business users to embed individual QlikView objects such as charts, list boxes, and graphs into SharePoint portals and collaboration sites. This integration helps organizations increase the return on their investment in SharePoint by improving collaborative decision making and helping to preserve a record of how decisions were made.
Where can we get more info about social Business Discovery?
See these resources for additional info:
- QlikView white paper: "Social Business Discovery: Optimizing Decision Making," October 2011
- The social Business Discovery page of the QlikView web site
- Video: "Social Business Discovery," October 31, 2011
Annotations (Notes and Comments, or Threaded Discussions)
What are QlikView annotations?
With annotations, QlikView users can now engage each other in discussions about QlikView content. A user can create notes associated with any QlikView chart, graph, list box, or other object. Other users can then add commentary to create a threaded discussion. Users can capture snapshots of their selections and include them in the conversation so others can get back to the same place in the analysis when reviewing notes and comments. QlikView captures the state of the object (current selections), as well as who made each note and comment and when, for a lasting record of how a decision was made.
What is the business benefit of annotations?
- Enable users to have discussions about the application or the data in the application, right there in context of their decision app
- Establish a record of how decisions were made
Are the contents of annotations included in QlikView search results?
Which editions of QlikView Server support annotations?
Annotations are available in QlikView Server Enterprise Edition (EE), QlikView Server Small Business Edition (SBE), and QlikView Extranet Server (QES). Annotations are not supported in QlikView Information Access Server (IAS).
With which QlikView clients do annotations work?
Annotations work with the Ajax client and Internet Explorer plug-in. They work with QlikView Desktop only when the user opens a document on QlikView Server from within QlikView Desktop. (Annotations are server based.) Annotations work on all mobile device platforms on which QlikView supports HTML5 browsers (Apple iOS devices and Android smartphones and tablets). For this to work properly, the device must be connected to the QlikView Server in full screen mode, not small screen mode.
Can users make annotations at the document level, object level, and data level?
Users can create annotations at the object level (per chart, graph, list box, etc.), not at the document or data level -- though users can access existing annotations at the document level via a toolbar option.
Can users take screen shots and post them in the conversation?
Users can take snapshots, which preserve the state (user selections) of the application. (Snapshots are like bookmarks, except a snapshot is specific to a discussion thread.) Users can post snapshots in notes and comments. Others can click on them to view the selections made by the person who created the snapshot. Keep in mind that snapshots are not static screenshots. They preserve the state of the application, but the underlying data may have changed. So that users know the data may have changed, QlikView Publisher posts a reload date/time stamp comment into the discussion thread.
Can users include images or hyperlinks in annotations?
Annotations in QlikView 11 support only text and snapshots.
Can users elect to receive alerts when an object has a new annotation?
Not at this time.
Can users create annotations during collaborative sessions?
Yes, users can create annotations during collaborative sessions. However, all annotations will be attributed to the user who initiated the collaborative session.
Can users specify that annotations be made available only to certain people?
Yes. When determining who can view a note or comment, users can choose from these three options: Only me, specific people, or anyone who has permissions to view the object.
Where are annotations stored?
Annotations are stored in the .SHARED file along with other collaboration objects.
How does the use of annotations affect application performance, memory utilization, and the size of the shared file?
There is an impact on the shared file. We will be monitoring cases where users see a performance degradation due to having a large body of annotations in place. We don't anticipate an effect on memory utilization.
How are annotations affected by updates to QVW files?
Annotations are preserved during reload. If an object is removed, the annotations are also removed.
What security does QlikView provide for annotations?
An individual annotation can be limited to specific named users. It can also be restricted to just the users who have permission to access an object.
Can annotations be edited by the user after the fact?
Yes, users can modify their own annotations after they have been saved. Users cannot modify annotations created by others.
When creating annotations (notes and comments) can users on an iPad create snapshots?
When using the annotations capability on iPad, users can create snapshots just fine. They can also click on snapshots others have created in notes. However, there is a bug in QlikView 11 that prevents users from interacting with the snapshots associated with comments (replies in the thread). Unfortunately, due to uncertainties regarding potential related problems and program priorities we cannot guarantee a fix date for this bug at this time.
Can annotations be extracted for legal discovery?
Not at this time.
Can administrators selectively remove notes and comments?
Using the QlikView Management Console, administrators can remove entire notes, but cannot remove individual comments from notes.
Collaborative Sessions (Shared Sessions)
What are QlikView collaborative sessions?
Shared sessions improve the quality of business decisions for geographically-distributed and mobile users who work in teams to analyze information and make decisions. Users can jointly interact with a QlikView app in real-time―sharing selections and testing scenarios together to better uncover insights and solve problems.
A user can invite others—even those who don’t have a QlikView license—to join a session by distributing a one-time-use URL. Each participant interacts with the same QlikView app at the same time, for the duration of the session—without having to pass control from one to the other. This new capability is designed to augment a voice conversation. Collaborative sessions work on tablets and smart phones as well as desktop and laptop computers.
What is the business benefit of collaborative sessions?
- Support conversations with the ability to jointly interact with a QlikView app in real time with other users
- Bring decision makers together in real time
- Improve the quality of business decisions for geographically-distributed and mobile users who work in teams to analyze information and make decisions.
- Support co-creation; developers and/or business users can jointly build or modify QlikView apps (to the extent that it can be done in the Ajax client)
Are collaborative sessions read-only for the invited participants?
No, collaborative sessions are fully interactive for all participants. All participants can make selections and interact with the QlikView app in real time. The session ends when the person who started it ends the sessions or closes the application.
What license is required to be able to hold collaborative sessions?
No additional license is required for collaborative sessions. Licensed users can initiate a collaborative session with anyone, including non-licensed users.
Are collaborative sessions available to QlikTech OEMs and information services provider partners?
Yes. It is up to partners to turn off this feature if they don't want to make it available to their users.
Which editions of QlikView Server support collaborative sessions?
Collaborative sessions are available in QlikView Server Enterprise Edition (EE), QlikView Server Small Business Edition (SBE), and QlikView Extranet Server (QES). They are not supported in QlikView Information Access Server (IAS).
What is the limit to the number of people who can participate in a collaborative session?
There is no known hard limit on the number of people who can participate in a collaborative session. We have tested it with ~19 people. But the realistic limit is the number of people who can realistically have a productive conversation. We recommend limiting it to no more than a few. Otherwise the interaction with the QlikView application could get confusing because QlikView does not identify which participant is making selections in QlikView.
Can invited participants forward the invitation link to others?
Yes. The invitation link is good for 15 minutes. After that, it will not work. During the 15-minute period, invitees can forward the link to others, who will be able to join the session. Prior to joining a collaborative session, individuals are invited to choose a user name. If "Donald Duck" joins the session, the initiator will be able to see this.
Does QlikView identify users who have joined collaborative sessions by their QlikView user name?
No. Keep in mind that non licensed users may participate in collaborative sessions. When invitees join a collaborative session, they give themselves a user name. The initiator of the session can then see that that user has joined.
Do collaborative sessions work on mobile devices?
Yes, collaborative sessions work on tablets and smart phones as well as desktop and laptop computers. Keep in mind that on smartphones, collaborative sessions do not work in small screen mode -- it works only in full-screen mode.
When using an iPad, can people engage in co-creation of analytic apps using collaborative sessions?
No application development is supported on iPad at this time. A user on an iPad could, however, participate in a shared session as a viewer while another person using the Ajax client on a laptop is creating and modifying objects.
With which clients do collaborative sessions work?
Collaborative sessions work only with the Ajax client. They do not work with the Microsoft Internet Explorer plug-in or QlikView Desktop.
Can users create annotations during collaborative sessions?
Users can view and create annotations during collaborative sessions. But keep in mind that during a collaborative session, all annotations are attributed to the user who initiated the session. Also: each participant in a collaborative session must click "show/hide notes" to have the annotations object appear on their screen. And participants do not see each other creating notes/comments during collaborative sessions -- though after someone creates an annotation and clicks "done," others in the session will be able to see it.
What security does QlikView provide for collaborative sessions?
An administrator can control collaboration sessions on a server and on individual documents. But the rights of the initiator are passed to the participants in the session. Caution: The initiator of the collaborative session must think it through before inviting others to participate in collaborative sessions. All users in a shared session can see and interact with the app as if they were the license holder, with one exception: while a collaborative session is under way the ability to download and export to Excel are disabled.
What steps should customers take before enabling external parties to participate in collaborative sessions?
All participants must have access to the QlikView Server. If a QlikView app is behind the firewall, all participants must be able to get to the server via the VPN.
How does the use of collaborative sessions affect application performance, memory utilization, and the shared file?
Collaborative sessions have no known impact on application performance or the size of the shared file. There is a small impact on memory utilization for each additional user. But as each individual user is sharing the same session, the impact is much smaller than if each user were to start their own individual sessions.
QlikView 11 Theme: Comparative Analysis
One of the core capabilities of QlikView is associative search. QlikView 11 takes our associative analytics to a whole new level.
What is QlikView comparative analysis?
Business users can quickly gain new kinds of insight when analyzing information in QlikView, with new comparative analysis options. App developers can now create multiple selection states in a QlikView app; they can create graphs, tables, or sheets based on different selection sets.
What is the business benefit of comparative analysis?
Business users can then compare multiple selections of data inside one app, one chart, or one object, to spot trends, outliers, or differences. This makes it easier for information workers to gain new insights into patterns of use, opportunities and threats, and relative performance.
Can users compare more than two sets of data using comparative analysis?
Yes, users can compare multiple different sets of data. The data can be displayed in a single chart or in multiple charts.
Can multiple dimensions and expressions be applied within a single group?
What is the difference between comparative analysis and set analysis?
Comparative analysis and set analysis complement and extend each other. QlikView developers can use sets to perform aggregation functions. Aggregation functions normally aggregate over the set of possible records defined by the current selection. But an alternative set of records can be defined by a set expression. Hence, a set is conceptually similar to a selection. Set analysis provides a method of defining groups (sets) of information that are independent of the current selections. Comparative analysis enables business users themselves, on their own, to create comparisons using multiple groupings of their choice. It could be used, for example, to compare sales for different products or demographics or analyze consumer purchasing baskets.
Which demo apps show comparative analysis?
You can see examples of comparative analysis in action in these demo apps, which are accessible on the QlikView 11 demo site:
- What's New in QlikView 11
- Brushing and Linking
QlikView 11 Theme: Mobile Business Discovery
With mobile Business Discovery, information workers can take advantage of being in a particular place at a particular time and generate insights “on location.” QlikView on mobile delivers full Business Discovery and the power of QlikView to mobile devices connected to a server—including the associative experience, interactive analysis, access to live data, and search. For Apple iPads, QlikView also provides offline views of data.
General QlikView on Mobile Questions
Does QlikView 11 support offline use on mobile devices?
Yes, QlikView provides offline views of data for iPads. The QlikView for iOS iPad and iPhone app, available in the Apple App Store, complements QlikView on mobile browser-based access. The app provides a native user experience for QlikView AccessPoint, while extending and enhancing QlikView’s universal HTML5 approach for analytics applications. Users get all the power and flexibility of QlikView Business Discovery when connected, and when using an iPad can take advantage of a new disconnected mode for offline access. And there are no additional costs, because the app is a free download and works with any QlikView 11 server license. For more information see the QlikView on Mobile data sheet.
Is there a native app available?
Yes, for Apple iOS devices. This app is an HTML5 wrapper. The iPad version provides offline views of data.
Does QlikView 11 provide location awareness?
Out of the box, location awareness is not supported at this time. However, with document extensions in QlikView 11, customers can create this functionality on their own. See this demo app: GPS Store Finder.
Is an additional license required to deploy QlikView on Mobile?
No, there is no additional license cost.
Does QlikView 11 include a mobile SDK (software development kit)?
No, QlikView 11 does not include a mobile SDK.
What additional info is available about QlikView on Mobile?
See these resources for additional info:
- QlikView white paper: "Mobile Business Discovery: Beyond Reporting," October 2011
- Data sheet: "QlikView on Mobile," September 2012 (originally published October 2011)
- QlikView on Mobile section of the QlikView web site
- Blog post: "Empowering the User on Mobile -- It's About Variety," October 31, 2012
- Blog post: "Mobile BI -- Online, Offline, and the Proper Context," June 2012
- Blog post: "QlikView 11: What's New in Mobile," October 19, 2011
Support for Browsers on Multiple Tablet Platforms
What are the benefits of browser support on tablets, vs. native app support?
Organizations can get better usability and faster time to value from their QlikView investments by giving business users access to apps via native HTML5 browsers on Apple iPads and Android tablets. This means users get a seamless experience with their QlikView apps across tablets and desktop and laptop computers. They get the same functionality and interactivity, without waiting for developers to create new versions of the app for each specific mobile platform.
What mobile device platforms does QlikView 11 support?
QlikView 11 delivers mobile functionality for Apple iOS and Android tablets and smartphones. QlikView supports Android tablets when the following conditions are met:
- QlikView Server version 10 SR3 or later
- The native browser, not a downloaded one
Currently our HTML5 web apps support only Apple and Android handhelds. Because many Blackberrys are older devices that don't fully support HTML5 (and many are non-touch), we don't have a web-based solution for them at this time.
What touch gestures does QlikView 11 support on Android tablets?
Organizations can get higher adoption of Business Discovery apps, and more value from their QlikView investments, by giving business users the ability to interact with mobile QlikView apps through a full set of native, intuitive, touch-based gestures. QlikView 11 on Android tablets supports many gestures including hold tap on a chart, get the green square, resize and select. We have tested this on Samsung Galaxy Tab and Motorola Xoom.
Does the Ajax client -- particularly on the iPad -- provide the full set of design and development capabilities of QlikView Desktop?
No, though with each new release we put more and more functionality in the Ajax client. QlikView Desktop provides functionality for designers and developers beyond the functionality in the Ajax client. Ajax, for example, doesn't support custom objects, automation APIs, and client side APIs. For more information see the QlikView Server and Publisher manual (download the manual here).
Do customers install a native mobile application to be able to develop apps while using tablets?
No. QlikView users can perform most of the same modifications to QlikView apps while using tablets that they can make using the Ajax client on their desktop or laptop computer. But QlikView Desktop is the primary development environment for QlikView apps, whether those apps are deployed to desktops/laptops or mobile devices.
Browser-Based Support for Smartphones
On which smartphones does QlikView 11 provide support for HTML5 browsers?
QlikView supports Apple iOS and Android smartphones. We have not yet tested it for BlackBerry smartphones. Customers that want to support BlackBerry smartphone users can do so with our older native BlackBerry client. QlikView on Mobile has not been tested with the browser on Windows Mobile devices.
In QlikView 11, how is the user experience optimized for small-screen devices (smartphones)?
When a user points their Apple iOS or Android smartphone to the application on QlikView Server, they will have the option to interact with the application in small screen mode. When they choose this mode, they will see all the sheets (tabs) and objects in the application represented by icons or thumbnails in a tile view. They can swipe on the screen to scroll through all the available objects. To access an object, they tap on the tile representing that object. They then see just that one object on the screen. They can interact with that object (making selections) just as they would in full screen mode.
What are the benefits of browser support on smartphones?
Information workers get improved usability by accessing QlikView on their Apple and Android smartphones using the device’s native HTML5 browser. When QlikView Server detects the user is accessing an app from a smartphone, the server automatically displays the app on the device one object at a time. For small-screen devices such as iPhone and Android Phone, single-object display mode delivers an intuitive user experience without the need for developers to rebuild apps.
QlikView 11 Theme: Rapid Analytic App Platform
With Business Discovery, there are no “end users.” Instead, every user is the start of something, a node in the creation of insight that is no longer highly centralized and radial. A rapid analytic app platform helps developers and business users contribute to the creation of analysis quickly and simply―without requiring extensive ongoing involvement from experts.
QlikView 11 includes new and improved capabilities that meet the needs of QlikView app developers and third-party software developers―as well as the needs of business users who want to create their own analytic apps.
General Rapid Analytic App Platform Questions
What additional resources are available about QlikView 11 as a rapid analytic app platform?
Please see these additional resources:
- The "Creating QlikView apps" section of the QlikView web site
- Video: "Remixability and Reassembly with QlikView," November 7, 2011
QlikView 11 makes it easier for developers to extend the platform.
General Extensibility Questions
Does QlikView support Eclipse the way it supports Microsoft Visual Studio?
No, QlikView does not support Eclipse. Our Workbench product, which is used to create web pages that embed QlikView -- or to build extension objects and document extensions, requires Visual Studio.
Does QlikView 11 enable users to export more than 65,000 rows to Excel?
Does QlikView 11 support export to the Excel .XLSX format?
QlikView supports export to Excel .XLS but not .XLSX.
Does QlikView 11 support emailing Excel output the way it supports emailing PDFs?
QlikView does not support emailing Excel output via QlikView Publisher. Users can, of course, email Excel files to others after exporting the data from QlikView.
How would customers integrate QlikView 11 into JSR-compliant portals?
QlikView 10 supports Iframe (inline frame). In QlikView 11 we also offer an HTML DIV tag option, which defines a division or a section in an HTML document. This should make integration with enterprise portals easier. Customers will still need to build a portlet around the DIV tag content and address security requirements
What are document extensions?
What are the benefits of QlikView document extensions?
Business users with the Ajax browser client gain a more streamlined, effortless experience when working with data from external analytic systems. They can interact with data returned from other analytic systems directly within QlikView—without having to access the external system in a separate, disconnected mode. Like the extension objects we introduced in QlikView 10. Once created, document extensions can be reused in multiple QlikView apps.
QlikView Workbench Extension Object Template
What is the QlikView Workbench extension object template?
The new Visual Studio project template includes all the files needed to build a working QlikView extension object and publish it to QlikView Server. The new Visual Studio project template also includes:
- Guidance on how to customize QlikView extension objects
- A user interface for creating a custom property pane for extension objects
- The ability to test extensions from within Visual Studio.
What are the benefits of the QlikView Workbench extension object template?
Developers can use QlikView Workbench to create QlikView extension objects in Microsoft Visual Studio more quickly and easily than ever before.
Does QlikView 11 provide out-of-the-box extension objects?
QlikView customers can download sample extension objects in a demo app called Extension Examples (download from the demo site here). This demo app includes an organizational chart, whisker pie chart, geographic heat map, bullet chart, and calendar view. Customers can find additional sample extension objects in QlikCommunity.
Do QlikView extension objects work with both Ajax and the Microsoft Internet Explorer (IE) plug-in?
QlikView extension objects work only with the Ajax client and web view mode in QlikView Desktop. They do not work with the IE plug-in.
What skills do developers need to build QlikView extension objections?
QlikView Connector for Informatica PowerCenter
What is the QlikView Connector for Informatica PowerCenter?
For more information, see this blog post, "QlikView Connector for Informatica PowerCenter Now Available" or download the data sheet, "Data sheet: QlikView Connector for Informatica PowerCenter."
What is the value proposition of the QlikView connector for Informatica?
Benefits of the QlikView Connector for Informatica PowerCenter:
- Unlock the value of your data warehouse: Informatica PowerCenter extracts data from multiple sources into a data warehouse. As part of the ETL process the QlikView Connector allows data to be exported in an optimized format (QVX – QlikView data exchange format).
- Speed of deployment: Deploy individual analyses and reporting solutions in weeks or days using the QlikView script builder. Expedite and simplify the process of analyzing relevant data from Informatica.
- Ease of use: QlikView is easy for business people to use and IT pros to manage. Most users become productive with QlikView after less than one hour of training.
What versions of QlikView support the Informatica connector?
QlikView 10 and higher.
What versions of Informatica PowerCenter does the connector support? On what platforms?
The QlikView Connector for Informatica PowerCenter supports the following Informatica PowerCenter versions on Unix and Windows: 8.6.1 and 9.0.1.
QlikView Connector for Salesforce.com Version 11
What is the QlikView Connector for Salesforce.com?
QlikView for Salesforce.com is a native connector within QlikView that provides a transparent and intuitive means for QlikView developers to access data from Salesforce.com. Installed as an add-on adapter, the .dll-based connector instantly offers a view into all out-of-the-box and custom fields within a Salesforce.com deployment, including Chatter data and archived data. Because it is a native connector, the speed at which data is accessed and loaded into a QlikView application is extremely fast. With this connector, QlikView customers can quickly and easily bring their Salesforce.com data into QlikView for exploration and analysis. Here is a blog post that contains more information, "QlikView Salesforce Connector Version 11.00 Now Available." More detail is in the data sheet, "Data sheet: QlikView for Salesforce.com" (download).
How can customers get the QlikView Connector for Salesforce.com?
Customers can download the connector from the QlikView download site.
What's new in QlikView Connector for Salesforce.com Version 11.00?
This version of the QlikView Connector for Salesforce is DLL (dynamic linking library) based and is available for both 32- and 64-bit systems. It contains some key enhancements:
- Supports Salesforce API 21
- Provides access to Salesforce Chatter tables
- Provides the ability to extract archived data
- Provides access to additional data types including anyType, time, encryptedstring, masterrecord, and DataCategoryGroupReference
Does the QlikView Connector for Salesforce.com support all SOQL (Salesforce object query language) calls?
The QlikView Connector for Salesforce.com recognizes a mix between SOQL and SQL that introduces both limitations and enhancements to SOQL. These changes have been made in order enable better communication between QlikView and Salesforce and for the sake of backwards compatibility. SOQL-style relationship queries are not enabled. The SQL-style date and time format “YYYY-MM-DD hh:mm:ss” is now automatically converted to the SOQL date and time format “YYYY-MM-DDThh:mm:ssZ.” Also, it is now possible to use an asterisk (“*”) in place of a field list. Similar to SQL, the asterisk acts as a wildcard that selects all fields in the table. Qualifying the field name by prefixing it with the name of the table is not allowed in the SELECT Statement.
Are any additional field types supported in this release?
This release of the connector recognizes a few more data types: “anyType”, “time”, “encryptedstring”, “masterrecord”, and “DataCategoryGroupReference.” The type “time” denotes a time of day, as opposed to the type “datetime” which holds both a date and a time of day.
With which versions of QlikView does the Salesforce connector work?
The QlikView Connector for Salesforce.com works with QlikView 8.5 and higher.
Improved Application Development
QlikView 11 delivers new and improved capabilities to make it easier for developers and business users to create QlikView applications.
Version Control (Source Control) Integration
What version control integration does QlikView 11 provide?
Using a new option in the File menu, QlikView developers connect a QlikView app to a source control system such as Microsoft Team Foundation Services or Apache Subversion. The source control system then provides change tracking and rollback and can merge changes made by multiple developers. Each element of the QlikView app―such as script, properties, and user interface object definitions―is stored separately and can have changes tracked separately.
For more information, see the QlikView Technology White Paper, QlikView 11 Source Control Walkthrough.
What are the benefits of version control integration in QlikView 11?
Benefits of version control integration include:
- When managing large QlikView deployments, developers and administrators can improve the efficiency of application development by accessing and utilizing a central source code control system directly from within QlikView Desktop.
- Development teams can more easily adhere to best practices.
Metadata Enhancements for Developers
What metadata enhancements does QlikView 11 provide for developers?
Developers can now use comments and tags during document construction to limit field selection (using search criteria), provide labels, and support data structure analysis. This expands upon the comments and tags introduced in QlikView 10.
What are the benefits of the metadata enhancements for developers?
When creating or editing QlikView applications, developers can more easily search for and find relevant data fields and visualization objects using comments, tags, and labels.
What additional resources are available about QlikView's approach to metadata?
See these links for more information:
- QlikView Technology White Paper, "QlikView's Pragmatic Approach to Metadata" (download from QlikView.com) (March, 2011)
- Blog post by Arthur Lee, "Metadata Made Easy" (July 19, 2011)
Improved Ajax Dialog Boxes
What are the improved Ajax dialog boxes in QlikView 11?
QlikView developers and business users can now create QlikView charts, graphs, list boxes, etc.—all of which can be shared as collaboration objects—using improved dialog boxes, drag and drop, and visual assembly. QlikView presents the most frequently-used menu items at the highest level, with others nested below.
What are the benefits of the improved Ajax dialog boxes in QlikView 11?
Creating QlikView objects (e.g., charts, graphs, and list boxes) in the Ajax browser client is easier than ever before, especially for non-technical users.
Are the improved Ajax dialog boxes available in Small Business Edition as well as Enterprise Edition?
Granular Chart Dimension Control
What is granular chart dimension control?
Granular chart dimension control enables developers to more easily create meaningful comparisons among dimensions in a chart.
What are the benefits of granular chart dimension control?
Developers can more easily display the lowest values, first values, top values, etc., in a single chart. In previous releases of QlikView, his required the use of macros and advanced aggregation functions.
Conditional Enabling of Dimensions and Expressions
What is conditional enabling of dimensions and expressions?
Developers can now manipulate QlikView objects to provide refined context based on a user’s action, selections, or role, or any underlying data condition. Developers can specify conditions that control when a dimension or expression is used on a chart, or when a table is used, based on any criteria.
What are the benefits of conditional enabling of dimensions and expressions?
One use of this new capability is to more easily support ad hoc report creation. (For an example, see the Reports tab in the What's New in QlikView 11 demo app.) Overall, conditional enabling of dimensions and expressions improve the user experience.
Container Object Enhancements
What enhancements have been made to container objects in QlikView 11?
Container objects give QlikView designers a means of presenting multiple perspectives on a set of facts in a single, space-saving object. In QlikView 11, designers can now create QlikView apps that are more efficient and user friendly by placing multiple objects on a single tab, snapped together in a grid.
What are the benefits of the container object enhancements in QlikView 11?
Container object enhancements make better use of screen real estate. Users gain consolidated viewing context.
Improved Tab Navigation
How is the tab navigation improved in QlikView 11?
In the Ajax client, we’ve improved the way users navigate from one sheet (tab) to another within a QlikView app. Users can now scroll through tabs to find the sheet they want, or select a sheet from a drop down menu. They can also add new sheets more easily.
What are the benefits of the improved tab navigation?
Improved tab navigation makes it easier for users to find QlikView content and add new sheets (tabs).
QlikView Direct Discovery
With Direct Discovery, a capability of QlikView 11.2, QlikView brings relevance and context to Big Data. QlikView Direct Discovery provides connectivity to SQL-based data sources such as Cloudera Impala and Teradata Integrated Data Warehouse. Within a single app, users can work with data stored in Big Data repositories as well as data in QlikView’s in-memory engine. With this hybrid approach, users get the associative experience across all data in the app, regardless of where it is stored—a capability unique to QlikView.
QlikView Direct Discovery delivers thorough, unified analysis. Users can easily expand their analysis to include Big Data sources that have not yet been tapped. They can drill down from in-memory data sets to detailed measures stored in Big Data systems. Direct Discovery delivers the same easy-to-implement, rapid app development experience to data sets that were previously used separately, or not used, because of their bulk and the development effort required.
General Application Development Topics
Does QlikView 11 feature improvements to the report designer?
No, it does not.
QlikView 11 Theme: Enterprise Platform
While Business Discovery platforms must deliver business user benefits such as insight everywhere, mobility, and a social and collaborative experience, they can’t stop there. Business Discovery platforms must also meet IT requirements for security mechanisms to protect sensitive data, the ability to crunch massive volumes of data quickly, and advanced yet easy-to-use administration tools. QlikView 11 is packed with new and improved capabilities designed to improve performance of large deployments and make them easier for IT pros to secure and administer.
Publisher Performance Improvements
QlikView 11 provides several new and improved capabilities to improve system performance.
How is the performance of QlikView Publisher improved in QlikView 11?
QlikView 11 introduces important changes to the QlikView Publisher component, which is used for reloading QlikView apps and distributing derivative QlikViews. We’ve significantly improved the performance of QlikView Publisher reload and loop and reduce tasks.
What are the benefits of Publisher performance improvements in QlikView 11?
Publisher performance improvements mean fresher data for business users.
Do document reload and distribution tasks use two separate QlikView engines?
Reload requires a QlikView engine which is terminated on completion of the reload. Another QlikView engine is used for distribution, which is also terminated on completion of the distribution.
Load Balancing Improvements
What improvements have been made to load balancing in QlikView 11?
We added an additional algorithm for load balancing, in deployments that utilize QlikView Web Server, to help QlikView administrators better manage a cluster of QlikView Servers. QlikView Web Server can now route traffic in several ways: randomly, by RAM (random access memory), and/or by CPU (central processing unit) utilization. These factors work in tandem. Administrators can configure the environment so that, for example, a large QlikView app is not moved to a server that may have plenty of disk space but is overloaded with processing.
What are the benefits of the load balancing improvements in QlikView 11?
These improvements help QlikView administrators better manage a cluster of QlikView Servers.
More Granular Clustering
How has clustering been improved in QlikView 11?
Administrators now have control over which nodes in a cluster execute which apps. For example, administrators can choose to assign larger QlikView apps to larger servers and can achieve better utilization of commodity hardware for smaller loads.
What are the benefits of more granular clustering in QlikView 11?
With more granular clustering, QlikView administrators managing deployments that have large data volumes can reduce the complexity and cost by optimizing resources.
Ease of Administration
QlikView Management Console Improvements
What are the QlikView management console improvements in QlikView 11?
We have usability tested the unified QlikView 11 management console for significant improvements in speed and ease of use. We’ve made improvements in areas like task searching and filtering, task execution history within the status task page, task templates and creation wizards, and event notifications (such as when a service is down).
What are the benefits of the QlikView management console improvements in QlikView 11?
The QlikView management console improvements in QlikView 11 save administrators time.
What improvements does the QlikView Management Console provide in error handling and event triggers?
In QlikView 11, the management console UI was changed to give administrators a much better experience overall, to better manage tasks, shared objects, etc. QlikView 11 also provides better and easier access to the logs. In this way, errors and triggers are much easier to manage. In addition, a global services error bar has been included, which makes it easier to detect events such as a service going down.
In QlikView 11, is it possible to categorize Publisher tasks internally and have a second, separate category that is meant for users (for access via AccessPoint)?
No, this is not supported.
What is AccessPoint?
AccessPoint is the QlikView portal where users can find and access QlikView apps to which they have security rights.
What has changed about AccessPoint in QlikView 11?
See below screen shot. New and improved capabilities include:
- A faster and more modern design
- Admins can assign characteristics/attributes to documents to make them easier for users to find and organize
- Users can search for apps
- Admins can provide descriptive text for apps so they are easier for users to find via search
- Users can “favorite” apps
- Users can more easily sort apps in a detail view
QlikView Management Services API Enhancements
How is the QlikView Management Services API enhanced in QlikView 11?
With QlikView management services API enhancements, administrators can programmatically interact with the QlikView management service to customize or automate various aspects of QlikView Server and QlikView Publisher administration.
QlikView 11 includes more than 50 new QlikView management services API calls that support automation in areas like collaboration object management, directory service connector lookup and validation, importing of tasks, remote administration, log file access, QlikView Server and QlikView Publisher license configuration, and section access management.
What are the benefits of the QlikView Management Services API enhancements in QlikView 11?
The QlikView Management Services API enhancements in QlikView 11 enable additional automation beyond what was possible with QlikView 10.
General Security Administration Questions
Does AccessPoint support SAML (security assertion markup language) authentication?
No, AccessPoint does not support SAML.
Does AccessPoint support SSL (secure sockets layer)?
Does QlikView 11 make it easier for admins to see which users have access to which documents?
We introduced changes to user management in QlikView 10 that made it easier for administrators to see which users have access to which documents. In QlikView 11, we changed the QlikView Management Console user interface to give administrators a much better experience overall. They can better manage tasks, shared objects, etc. However, no new changes were implemented to give increased visibility into user authorization.
What is document-level auditing in QlikView 11?
New optional settings within QlikView Management Console enable administrators to more effectively audit user interactions. Administrators can audit QlikView usage not only at the system level (the entire QlikView Server), but down to the document level.
What are the benefits of document-level auditing in QlikView 11?
Document-level auditing helps administrators improve risk management and compliance. Administrators can improve the accuracy of audit results when conducting a usage audit by tracking which users access what documents, and performing this analysis retroactively.
What information does the audit log capture?
The audit log on QlikView Server captures information such as a time stamp, the name and path of the QlikView document / application, name of the user, type of selection action (e.g., selection, bookmark) made, and information about the type of selection or the application of a bookmark.
Granular Download and Export Control
What is granular download and export control in QlikView 11?
QlikView administrators can now assign privileges at both the document and user level.
What are the benefits of granular download and export control in QlikView 11?
QlikView administrators can improve control and manageability when applying privileges for document download and/or data export.
Publisher QVD Generation Task
What is the Publisher QVD generation task in QlikView 11?
QlikView developers and architects can now manage data by creating QVD (QlikView data) file layers from a centralized, server-side, QlikView Publisher location. Developers and architects can now create QVDs without the additional overhead of managing a QVW file solely for the purpose of creating a QVD; they can create QVDs via a script. Optionally, QlikView administrators can also assign NTFS (New Technology File System) security to QVDs using this mechanism.
What are the benefits of the Publisher QVD generation task in QlikView 11?
Central data management is easier than ever before for QlikView developers and architects.
Does this new capability mean that admins no longer have to generate QVDs using the QVW script?
Correct. QVDs do not have to be generated in the script of a QVW now, for basic QVD generation tasks.
What flexibility does Publisher provide regarding QVD loads?
QVD loads should support anything that can be done in the QlikView script. But we recommend that customers use Publisher to generate QVDs only for basic implementations. For more complex implementations, we recommend customers continue to use QVW files as the engine for creating QVDs.
The QlikView Governance Dashboard
The QlikView Governance Dashboard helps IT professionals maximize data governance and optimize their QlikView investments by discovering how QlikView is used at a granular level. With this knowledge, they can introduce more manageable and repeatable processes when developing QlikView applications, as well as address data lineage and impact analysis questions. They can also ensure compliance with regulatory acts, policies and standards that require an understanding on how data is created, protected and delivered. The QlikView Governance Dashboard is a free QlikView application available on QlikMarket (market.qlikview.com).
General Enterprise Platform Questions
What additional resources are available about QlikView 11's enterprise platform capabilities?
See these additional resources:
- Data sheet: QlikView in the Enterprise
- The "QlikView empowers IT" section of the QlikView web site
- QlikView white paper: "QlikView Architectural Overview," October 2011