It allows our company to view all of our data in a single solution. It is easy to use, even for novice users.
Director of IT at a tech services company with 51-200 employees
QlikView on the Clouds
With the #cloud and #BigData becoming more relevant for enterprises, there is a lot of interest to explore ways of using QlikView on the Cloud. While discussions on private cloud, public cloud and hybrid clouds are continuing, I would focus on using QlikView on Infrastructure on Cloud in this short coverage.
Any enterprise wanting to run QlikView on an off-premise “Cloud” infrastructure can do so by using the QlikView image available on Amazon EC2 cloud. This can allow enterprises to create off-premise, often distributed deployment of QlikView. In essence, running QlikView on Amazon EC2 is very much like running QlikView in-premise. The licenses for QlikView are required to be purchased. The software distribution need not be installed on the Amazon EC2, but a ready-made image of QlikView already available on the Amazon can be chosen and deployed in no time. Refer how QlikTech uses Amazon to run the Demo environment.
The key aspect is, like any other cloud deployment, data stays in cloud. Where enterprises have their current data in the enterprise data center, then moving the data to the cloud could become a bandwidth intensive exercise. Companies who have data already on EC2 are luckier.
Extraction of data into QVDs from their source, and transferring QVD files over to the cloud server is a good way to optimize bandwidth and storage usage. Even if applications like CRM etc. are already in cloud, they exist in separate service providers, and the data still needs to be transferred to the virtual server where QlikView is running. Bandwidth will still be used for the same amount of data.
Following are some key situations when an enterprise can look at cloud:
1. Quick pilot to be done, without waiting for infrastructure additions
2. Do not want the upfront capital costs for server hardware
3. Need a flexible quickly scalable solution
4. Relatively less amount of incremental data being generated
5. As for security, the features of security discussed in chapter “QlikView Security” are relevant in the cloud deployment as well. Integration with data sources and portals are all the same as the in-premise deployments.
Some of the benefits in using cloud deployments include:
- Zero infrastructure requirements
- Elastic scalability
- Instantly available
- Users are up and running in 15 minutes
- Standard QlikView user license pricing (licenses can be moved from and to cloud)
- Shifts expenses from capital expenditures to operational expenditures
- Platform neutrality - Available through Amazon’s fast and reliable Elastic Compute Cloud (EC2) Web service
Currently, most organizations cannot move completely to cloud, but need a coexistence of in-premise and cloud infrastructure/solutions. QlikView can also be implemented in a hybrid fashion, to take advantage of the cloud benefits. QlikView is not available as a “Saas” or a “PaaS” offering at the moment. OEM offering of QlikView allows OEM customers to custom license QlikView and deploy on a multi-home/multi-tenant servers to offer pay-per-use services. For more information, refer to QlikView Blog: “QlikView and the Cloud - Have it your way” and QlikCommunity discussion “QlikView in the Cloud”.
Integration of QlikView with SalesForce, Workday and other solutions like OrangeScape is possible. Lot of companies who use SalesForce have integrated the QlikView dashboards into the SalesForce portal itself, as a separate Tab. The same is possible with other applications, to embed / integrate QlikView into the cloud front-ends seamlessly.
Integrating employees and extranet users (intermediaries, partners, customers and vendors) is a need in many situations, providing interactive analytics to them. One large global security appliances company has integrated QlikView into their SalesForce interface to provide analytics to their vendors. Implementing Single-Sign-On - using various identity stores is another aspect - where there are challenges. Solutions are emerging through integration partners. Security aspects of this integration need careful planning and execution - require a deep understanding of what is possible. Also the various deployment options need to be kept in mind while planning a cloud integration. I have treated these at length in my book.
With more and more cloud solutions emerging, integrating QlikView on Cloud and offer as a cloud SaaS is slowly emerging as a solution of choice, among the Cloud SaaS providers. More movement of QlikView to the cloud is a natural progression I believe.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
IT Manager at a consumer goods company with 501-1,000 employees
It reduced the number of reports users construct manually.
What is most valuable?
How has it helped my organization?
The product has reduced the number of reports that were previously constructed manually by users. It also allowed us to prepare a single report using a common data source for all users.
What needs improvement?
In QlikView 11, there is a password for the section of code, but there is no user management with a password that allows access to data when opening the file.
I would like the data loading and programming to be made easier.
For how long have I used the solution?
I have been using it for five years. Currently we're using v11.20 and testing v12.
What was my experience with deployment of the solution?
The product installed at the time did not present operational problems or stability issues.
How are customer service and technical support?
The consultant company that sold us the product provides us with follow-up service. At the moment, we are satisfied.
Which solution did I use previously and why did I switch?
I used BOARD at another company. I have found QlikView to be better.
How was the initial setup?
The initial setup was very simple and in a few days, we were able to begin operating with the data available.
What about the implementation team?
We developed the solution partly in-house and partly with the supplier. We took responsibility for the preparation of the database, retrieving information from the management system and preparing it in a suitable format, leaving the supplier responsible for the implementation of the loading from this database and reporting.
What's my experience with pricing, setup cost, and licensing?
We are happy with the product. With regard to the license fee, for a customer, it is always better to pay less.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
QlikView
January 2025
Learn what your peers think about QlikView. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
831,265 professionals have used our research since 2012.
BI Expert at a consultancy with 10,001+ employees
Works well when you have the right hardware to support it.
QlikView is a powerful visualization and data discovery tool, and works well when you have the right hardware to support it. I've seen the users getting excited about the tool, and the usage ever expanding in most places, provided the KPIs available are relevant.
The tool offers much more capability than simple dashboarding - the natve qvd file formats are excellent if you want to do lots of data cleansing and massaging. Due to this reason, clients can avoid having a separate database license for DWH (please note that QV is not a full fledged DWH, though it supports the most wanted functionalities).
QlikView works out to be the best cost effective when the number of users vary between 50 to 250. Users above or below may have its impact on the pricing per user.
In a nutshell, it is a great product to create leadership dashboards setup for any organization size.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Hi Andy, I agree, however it really depends on the quality of the developer. The problem that many of my clients face from the market is that even persons having 4-5 months experience calls themselves a QlikView expert; and when it comes to actual delivery, he/she suffers. From a learning curve perspective, I would say that first 30% of QlikView scripting is very easy (this gives a false impression of the tool being very easy to master), the next 40% requires 5 to 6 end to end implementations, and the final 30% is the most difficult part. I've seen very few people exploiting the complete functionality of the tool. If you have the right resources, and have developed reusable components over time, the scripting time can be minimized.
Project Manager, Global Business Intelligence & Analytics at a media company with 1,001-5,000 employees
Drag & drop storytelling provides value. I’m hoping to see mobile and smart device delivery.
What is most valuable?
The most valuable features of this product are: its data modeling capabilities, the associated search function, various charting, the flexibility of doing sales in object, section access, and drag & drop storytelling.
How has it helped my organization?
We have been using Qlik for most of our front-end solution since adoption; people like it a lot.
What needs improvement?
I would like to see:
- Mobile and smart device delivery
- Set analysis simplification
For how long have I used the solution?
I have used it for 3-5 years.
What do I think about the stability of the solution?
Performance sometimes is a concern.
Occasionally, it hangs while running a script and it bounces out.
How are customer service and technical support?
Technical support is OK. We work with a vendor partner. We have no direct interaction with Qlik.
Which solution did I use previously and why did I switch?
We used IBM Cognos BI, in which charting and dashboarding are painful.
How was the initial setup?
Initial setup was very easy.
What about the implementation team?
A vendor partner implemented it.
I advise your team to dive in and learn how to build the most-efficient data model, and learn how to design your web pages.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Information Publishing Portfolio Manager at a comms service provider
My most valuable asset in QlikView is the ease with which any datasource can be integrated into the QlikView model for reporting.
What is most valuable?
The traditional BI tools are extremely limiting in the fact that they require very strict controls on the sources of data. This is understandable in very large corporates, but in a small- to medium-size business, where most supporting data sources are nothing more than an Excel spreadsheet, this is a pain. Therefore, my most valuable asset in QlikView is the ease with which any datasource can be integrated into the QlikView model for reporting.
How has it helped my organization?
The models created by QlikView have put critical information at the fingertips of management for decision-making processes. Our warehouse and distribution managers now have a view of the movement of stock, fulfilment of orders and can plan for demand more proactively. We produce our management sales dashboards daily and use the tool to integrate proof of delivery documents with sales orders.
What needs improvement?
I have several lower-level users who don’t need full functionality of the tool, but do need to access more than one model. In this regard, the licencing structure is limiting and costly for a user who is not using the analytical aspects of the tool. QlikView only offers full-user CALs (expensive) and document CALs (less expensive), but those licences only allow the user to access one model.
For how long have I used the solution?
The business has been using this product for four years.
What was my experience with deployment of the solution?
I did not encounter any deployment, stability or scalability issues.
How are customer service and technical support?
Our implementation provider is very capable, but it is important to partner with a vendor who has industry, regional and technological capabilities, as this cuts down the time to develop customised requirements. Also, it is not necessary to limit yourself to one vendor and lots of freelancers are cost effective for specific requirements.
Which solution did I use previously and why did I switch?
I looked at IBM Cognos, SAP BusinessObjects, and MicroStrategy. The main draw cards to QlikView was the cost and flexibility.
How was the initial setup?
Initial setup was straightforward.
What about the implementation team?
A team from the implementation provider did the installation and it was simple.
What was our ROI?
Our ROI is the ability to immediately take catalytic interventions with information at hand, implementing immediate savings from lost business and being able to put products to market more effectively.
In-depth analysis on the user roles using the tool should be done prior to implementation as non-managerial staff could probably use a shared licence scenario enabling lower licence count.
What other advice do I have?
If possible, a site visit to other consumers of the tool often sheds a lot of light on work that can be done before implementation to overcome unnecessary problems and delays. For example, properly mapping financial processes, documenting and getting them signed off before a QlikView model is developed will save time and money in rework after the fact. Also forming a network of other users who are not related to the vendor is very valuable in getting unbiased advice.
It is quite versatile and reasonably cost effective.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Developer with 501-1,000 employees
The Set Analysis Wizard allows us to create subsets in a smart, fast way. It allows you to control the results, taking into consideration user clicking and selecting data.
What is most valuable?
- ETL functionality is hugely important, as data rarely are provided smooth and clean, even when the assumption is it has been cleaned beforehand. Plus, usually in BI, we need to create custom groupings, and being able to do that in script ad-hoc is very helpful
- Scripting for loads, with lots of functions, and insert script possibilities all provide extremely good flexibility for development.- Overall flexibility and ease of development is great for ad-hoc quick fixes, quick workarounds, which happen in BI
- Set-analysis function, unique for QV, is an awesome way to create subsets, literally under any chart/table/text box needed in a smart, fast way (replaces long expressions such as “if...then...“). It also allows you to control results, taking into consideration user clicking and selecting data.
- Associative model is super handy to just take an overview of data quality through visual associations (power of grey).
- Data governance is an extremely usable feature; there is no need for BI to build its own app, and it helps with licence monitoring.
How has it helped my organization?
With QV, literally all departments across the company have started “owning” data in terms of getting hands on data, knowledge about data, how it is built up, and the ability to slice and dice, add, expand, or decrease the size or granularity of their own reports.
This in turn has in general decreased the “fear” of touching applications on computer. With backups maintained by IT, people are given more freedom to try and change applications themselves.
What needs improvement?
Regex. Cleaning out data during script regex could be really handy.
Otherwise, I am having a hard time thinking of any other areas with room for improvement.
For how long have I used the solution?
I have used QlikView 9 for two years, I am trained and certified on
QlikView 11, and I have used QlikView 12 for half a year.
What was my experience with deployment of the solution?
I have not encountered any deployment, stability or scalability issues.
How are customer service and technical support?
I have not had direct contact. Currently (with Qlik Sense), I am working with Qlik local partners, not directly.
Which solution did I use previously and why did I switch?
Before QlikView, Excel was used across the company. At the same time, we had SAS Web Reporting Studio provided by my company’s headquarters, which was very far from even being considered to be used for anything beyond just comparing total sales numbers if the QlikView reports were in line.
How was the initial setup?
I remember it being set up with the first production app running in three days. So, initial setup was straightforward.
What about the implementation team?
Implementation was done in-house.
Which other solutions did I evaluate?
During the selection of the local BI tool, the choice was between IBM Cognos and QlikView. We were naturally showcasing to management how easy it is to use the UI, and the latter one was chosen.
What other advice do I have?
I think it is the best BI product out there, competing only with its own “brother” Qlik Sense. (While the latter is not that mature yet, it is definitely growing in power extremely fast.)
QlikView is a good choice!
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Managing Partner at PBS
It has an associative data exploration feature and provides good performance with one hundred million lines of data.
What is most valuable?
Data exploration and in-memory capabilities: It has an associative data exploration feature and can handle one hundred million lines of data and provide good performance.
How has it helped my organization?
N/A. We are consultants.
What needs improvement?
Qlik has launched another product, Qlik Sense to improve ease of use for the end user. The product lacks PDF exporting, mapping – which costs extra - and reporting features. Also, it turns the data into QVD format that is not accessible by other software.
For how long have I used the solution?
We have been using QlikView for five years. We have been a partner for five years as well. We have successfully completed seven QlikView projects.
What was my experience with deployment of the solution?
I did not encounter any issues with deployment, stability or scalability. It is quite easy to install, configure and deploy.
How are customer service and technical support?
QlikView has a very good developer community where you can find support from the other developers.
Which solution did I use previously and why did I switch?
We usually position this product for departmental and fast-win solutions. When you’re an expert in this product, it’s quite easy to develop well-functioning and complex dashboards.
How was the initial setup?
Initial setup was quite easy.
What's my experience with pricing, setup cost, and licensing?
QlikView has CAL and Document CAL licencing. It’s quite cost-effective when lots of end users use several reports like once a month.
What other advice do I have?
If you plan to develop dashboards and want the end users to further develop the dashboards, it requires some IT skills. If the end users should develop their own reports, Qlik Sense should be chosen.
Disclosure: My company has a business relationship with this vendor other than being a customer: My company is a Qlik partner.
Analista de inteligencia de mercado at a university with 1,001-5,000 employees
It is possible to work with a large amount of data without affecting the performance.
What is most valuable?
It is possible to work with a large amount of data without affecting the performance.
How has it helped my organization?
It improved development, because we could just put our data into it and start working, even with datasets with millions of records. Its high speed has also improved my organization.
What needs improvement?
It would be great if this software had better transforming tools. We can do a lot of heavy work with scripts, but sometimes that gets really messy.
I mean that it would be very good to have a graphic tool to manipulate the data.
I work with IBM Modeler, and I love how easy it is to transform data in it. I think QlikView could implement a graphical interface to manipulate date, just like Modeler. I also think thats way off the scope of QlikView, but I am just thinking how great it would be to have such tool built in.
For how long have I used the solution?
I have used it for four years.
What was my experience with deployment of the solution?
I haven’t found any problem with deployment, stability or scalability yet.
How are customer service and technical support?
Technical support is very good. Every question I had, there was someone to help me.
Which solution did I use previously and why did I switch?
I started working in my actual job because of this software, so I didn´t have the opportunity to choose it. However, I can see it´s great software, and I´d surely choose it.
How was the initial setup?
There wasn´t any problem with the setup, it was very easy (much easier then Oracle OBIEE).
What about the implementation team?
When I got access to it, it was already implemented. I just upgraded one time, without any kind of problem.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free QlikView Report and get advice and tips from experienced pros
sharing their opinions.
Updated: January 2025
Popular Comparisons
Microsoft Power BI
Tableau
IBM Cognos
Oracle OBIEE
Domo
Looker Studio
Zendesk
Microsoft SQL Server Reporting Services
SAP Crystal Reports
Sisense
Pentaho Business Analytics
Zoho Analytics
Plotly
Knowage
Buyer's Guide
Download our free QlikView Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- QlikView or Tableau - Which is better?
- Ad Hoc Reporting: QlikView vs. MainFrame Focus
- What's your experience or opinion about Spotfire vs. Tableau vs. Qlik?
- I currently use Panorama Necto as a viewer on SQL Analysis services cube--what other solutions are out there?
- Which is a better for reporting, SAP BO or QlikView?
- Spotfire vs. QlikView. What can one do which the other cannot?
- Tableau vs. QlikView - functionality and pricing schemes
- A journalist is writing a story about which Data Visualization software product to choose. Can you help him?
- A recent user: "I've done some primitive comparisons between Tableau, QlikView and PowView." Have you compared these?
- Does QlikView support my requirements?
Using QlikView on cloud would drastically reduce a company's costs in terms of hardware acquisition and increase performance.