The improvements in QlikView 11 are based on core ideas to help people make decisions. As an example, let’s take this story;
A Regional Sales Manager wants to identify areas where he can improve sales. He produces reports to see figures, and finds sales down in one area and so he organises to visit the Sales rep. He finds out that a lot of his product information is out of date, so he puts in place a regular training program and follow-up process. There are 3 inputs that would affect that sales result; the people, the environment and the data.
Qlikview 11: Support for multiple sources of insight; what helps people make decisions?
1. To support People working together:
• Social Business Discovery
2. To support access to and quality of Data:
• Improvements to the Enterprise Platform.
• Agile analytic app. platform.
• Core Platform Improvement analysis.
3. To support effectively working in the current environment:
• Mobile Business Discovery.
Qlikview 11: New Features to be released soon
Expected Release date: November 11th for general availability
• Social Business Discovery
All significant business decisions are made in groups. Decisions come through collaboration. QlikView allows users to collaboratively create Business Discovery Applications. One person may gain an important perspective from creating a new sheet or bookmark. This perspective can be incorporated back into the main dashboard with the data integrity being kept. This means others can gain the same value, rather than reinventing the wheel!
Qlikview have built-in collaborative capabilities to share information in real time with SharePoint. SharePoint brings together objects and shared bookmarks into one document or dashboard. You can even send a link to a Qlikview document/dashboard without a QlikView license! This entitles each of you working on the document to discuss what is displayed on the screen.
There is a new annotations feature also included to drive improved value of decisions; people will now be able to share insights directly to objects. This works by right clicking on an object and attaching a new note. Next you create a title, and add comments about what was seen in the data. The note then becomes attached to the object and a bubble shows the number of notes attached. You are then able to see comments others have made. Everything is time stamped. If data is refreshed you are then able to see that. This is a special type of bookmark, creating a link to a bookmark filter within the comment that has been added to an object.
Enterprise Platform (QlikView Server)
Enterprise Platform helps to make it easier for IT professionals to maintain the Enterprise Server. Performance is improved, with publisher roughly 40% faster! Clients are more in the loop with reduced process. Load balancing is improved, plus the complexity and cost is reduced to better manage clusters of servers, and the control of documents.
With the ease of administration, development of applications becomes more efficient, enabling direct integration of source control systems (such as MS Team Foundation Server). This enables systems to be developed together and tracked separately.
There have also been improvements within the Management Console User Interface. These included improvements to navigate with less clicks. Access point has been redesigned to a modern, user-friendly portal experience for any users to find the applications they want, plus enable them to search and have favorite apps.
The Security Administration has been improved with document level auditing down to application level. You are now able to assign the ability to download, or even export data by user. QVD layers are created from a centralised server location, rather than going through QlikView QVW files.
Agile analytic app platform
QlikView’s view is that with Business Discovery there are no end users! Every user is the start of something. The Qlikview Platform allows you to develop quickly and painlessly rather than traditional platforms which usually take a long time to design and deploy. With QlikView it was about developing quickly and painlessly in a way that business users add to the creation if they wanted to. What has been crease is a rapid time to get your dashboard up and running, as part of this highlight the flexibility.
There is a simplified user interface; allowing users to make more efficient objects, a grid layout is used where several objects can be clipped together to look at data, with more context and easier navigation. Most frequently used menu items are now shown in a dialog or favorites box at a higher level, to make it more intuitive to create QlikView objects.
There are now also more ways to work with data, with Meta data enhancements; you are now able to take the comments and tags capability to provide labels to support data structure analysis to limit field selection. Conditional enabling of objects has been added so that you can develop objects where the content will change depending on particular conditions. This will also result in performance enhancements. There is also new integration with information data warehouses.
Sneak peek, will also look at social media integration in the future. Where you could have marketing trying to put together social media sales campaigns, see Linked-in or Facebook alone side business information, so that you can see it all in one place, plus identify issues and trends.
Core platform improvements
Document level extensions, have Google analytics extension that will allow you to show the results without rendering the chart.
Meta data for users will expose more information for end users.
New Mobile technology, built on what we have, with no client specific to the device, so you don’t have to create a separate client for each new type of client. Browser based and will run on multiple touch screen devices. Full associative experience rather than a cut down version.
Android and Blackberry can now use Qlikview rather than just iPad. They also now have the support for smaller devices and screens through delivery of a single object mode. Nothing special needs to be done to reconfigure for the small screen and will work intuitively on the small screen.
Sneak Peak, Software Development Kit, embed QlikView functionality into mobile apps.
Push the envelope on the type of analysis can be done. Comparative analysis can now create multiple selection states so that business users can then create objects and associate them with this state. For example, below is a dashboard of regional sales for beverage and dairy that need to be compared in 3 regions around the world. US market the beverages is stronger than the food. It’s very simple to look at, but very technically complex to put together, theoretically not in QlikView.
Released Earlier in Version 10
Visualisation (Building the user interface)
You are now able to search over multiple fields. See below how we can search by region and item at the same time, we don’t have to go through separate list boxes.
Multiple Search and Selection Box Example
Current selections box now has a drop down.
So we can easily see what records are included
Current Selections Box
Several sheet objects can share properties. For example, any change made on one sheet will also happen on other sheets. By dragging and dropping objects (using the pivot table/chart) from one sheet to another. In this way objects are dragged and dropped in such a way as to be linked, you will see a chain symbol when you copy them so you know they are linked.
Scripting enhancements released in Version 10
ODBC administrator can be opened from within the administrator.
Meta Data allows comments and tags to be added to fields to give information on what the source details are. These are available in the table viewer, are able to be viewed by hovering over them. These can also be seen in the document properties; the comments for each table are listed. Setting tags will help the design process as it will sort the fields to the top when viewing in design dialogue boxes.
A new syntax check, cursor jumps from error to error so they can be fixed.
Chart expressions can be given explanations for the same variables and input fields that are linked to the same record. A new file data source called a QVX is available.
QVD is a closed format; however it improves the speed that data can be brought into Qlikview. Now we have QVX these are externally exposed, and supplement QVD files. QVX is used in the Extract Transform Load (ETL) process as it is reloaded. QlikView will connect allowing one document to handle multiple ODBC connections, and it also allows a 64 bit QlikView to a 32 bit ODBC driver. QVX stream allows QlikView to handle multi threaded load or connect statements, making better use of hardware available.
QlikView Server and Publisher
All things related to user management have now been moved to one tab. For example;
What documents users have access to,
- what collaborations objects users have created,
- which CAL’s are allocated,
- what groups they belong to, and
- Also what activity a user has been part of.
Qlikview Publisher (available with server)
The additions to Qlikview publisher are;
We can now create and manage tasks for documents, and audit file logging. For example, who has downloaded what and when.
There are now granular collaboration permissions; giving better control who can and cannot collaborate on what.
There is a central place for central access tables. This will then update in all QlikView documents where the table is used. This makes development maintenance faster and less error prone.
Tasks now can be copied, pasted, plus imported tasks are now included to get tasks from other documents e.g. to test to production. Tasks are usually around what reports are scheduled to print, from users to a scheduled time.
Processes available around setting up tasks;
- Make a document visible or not on a mobile device.
- PDF distribution to folder.
- Task and triggers, by multiple events e.g. when task 1 and 2 are completed.
- Set a notification email after a task has been completed, 1 notification per task
- A log history of tasks is visible
Improving session recovery for mobile clients;
When a user closes a session on a mobile device, behind the scenes, a QlikView bookmark is created on the server so next time the user opens they can start from where they finished.
A throttle value can be set on the server to manage the CPU usage of server.
It is possible to connect to LDAP or ODBC to any database and clustering of server directory services.
Software Development Kit (SDK) is included with QlikView server and includes all available API’s, exposed via web service eg java script API, used in the development of QlikView.