Our primary use case of this solution is to provide reporting to our customers. The company works with online solutions for marketing so the customer gets insights about the response to email components and things like that. I'm a freelance database specialist and the company is a customer of QlikView.
Database Specialist at Zwarthoed IT Solutions
Provides good functionality and a range of reporting to customers
Pros and Cons
- "Easy to analyze data by click-through."
- "The user interface is old."
What is our primary use case?
How has it helped my organization?
This is a tool with a lot of functionality to provide any kind of reporting to customers, it has a range of solutions. Although some customers would like to use different tools QlikView is what they're used to using.
What is most valuable?
The most valuable feature for me is probably the ease with which you can analyze data by click-through.
What needs improvement?
The user interface of QlikView is old. The provider built a new tool called Qlik Sense. So Qlik Sense is basically the offspring of QlikView. Somehow both are still supported and they've developed new versions for both of these tools but Qlik Sense is basically the restyled version of QlikView. There's a lot of discussion about some features which are difficult to use including the user interface, all look and feel aspects, but I think that will be in the new version. What they could provide is a migration path to Qlik Sense. It's very difficult to do that automatically because it always requires you to check and change some new port. I haven't researched it but I believe that's the case.
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.
For how long have I used the solution?
I've been using this solution for around six years.
What do I think about the stability of the solution?
The solution is stable but you need to tweak it once you set it up. The big issue with it is that it's a BI tool, so it's memory intensive and for some calculations also CPU intensive. It means that when it hits its maximum in terms of the resources available it starts to shut down.
What do I think about the scalability of the solution?
The solution is scalable but you really have to keep in mind that it's configurable in application so that if you reach the maximum, you know you need to act on that. Otherwise strange things will start to happen. We had that issue one time, we added more memory and since then we haven't had any issues.
How are customer service and support?
We have an intermediate company which we bought a license from and it provides us with support. Usually they're not very helpful. Either we find the answer more quickly ourselves, or if we can't find the answer, they usually also can't find the answer. So they have to forward it to the QlikView support. I think it's a waste of money.
How was the initial setup?
The deployment on premises is quite complicated. I did it myself but my predecessor neglected to make proper documentation about installation and the solution requires a lot of components on different servers that talk to each other and you need to set firewall settings and things like that. It's quite a big application. They could improve on that and they probably did that with Qlik Sense. There's a lot of manual stuff required which is not really necessary.
We have about 30 users in the company who are really customers. They access the reporting through a web console which sees it in the mail and some of them are external users who developed on the application. My role is more the maintenance of the application itself. I'm the one who installed it and updates the system. It's difficult to know whether our usage will be increased. This is a difficult year for everyone. If a company has to cut its budget, one of the first things to go is usually marketing.
What other advice do I have?
It's a very good product but I would recommend going for Qlik Sense because it has a better future, given that it's basically the new version of QlikView.
I would rate this solution an eight out of 10.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
IT Admin at a logistics company with 501-1,000 employees
Preparing daily reports without requiring additional manpower was the biggest benefit.
What is most valuable?
We appreciate the different methods how data can be provided to a developer, designer and end users. Develop new reports from production databases to final reports without additional tools and
the high-performance loading data from database without any performance issues on the database environment. The loading performance of QlikView data container.
How has it helped my organization?
With the solutions of QlikTech, we are able to provide management with requested reports with proven data within a short time.
We can scale the user properly for the report environment in different and multiple ways.
Preparing actual daily reports without requiring additional manpower was the biggest benefit for our company.
What needs improvement?
We would like to provide our customers with reports in PDF or other popular formats that are not included in the publisher; additional licenses are required for the print and PDF tool. From my point of view, a reduced functionality for this should be included with Enterprise Server Edition or Publisher.
But so far, every new version includes new benefits for us.
For how long have I used the solution?
We have used QlikView since 2010. That includes one year of testing QlikView Personal Edition for development and comparing the functions with our previous BI solution. We started using QlikView in production at the end of 2011.
What was my experience with deployment of the solution?
We implemented different versions of QlikView within a few years, starting with version 8, Small Business Edition to Enterprise. We also moved to new hardware environment, but never had any issues. All versions we had in production were always stable. At the same time, we never used the first release of a new version for the server environment; the QlikView application has always been tested. Developing and deploying new reports are always tested in test environment before we publish. Scalability of reports should be considered separately.
How are customer service and technical support?
Issues with the software itself are really rare; we just needed help implementing license keys after installation because direct internet access on the server was not available one time during setup. We always get help within a short / acceptable time. Normally, we just use the big user community for further help or information.
Which solution did I use previously and why did I switch?
Before 2012, we used SAS and Crystal Reports for reporting and BI. When we started looking for other solution, we evaluated the new version of Crystal Reports, but there was no comparable alternative to QlikView.
How was the initial setup?
A comprehensive concept for the initial setup is very important; there are various ways to implement the server infrastructure. If the concept was done properly, implementation might be complex but not difficult. We never had to contact QlikTech for additional support.
The documentation itself, user forum and several tech days was always helpful to start.
What about the implementation team?
We implemented the whole environment without any additional support. Before we start working with the product, we organized in-house training from a vendor partner for developers and report designers based on our requirements.
My advice for implementation is to create a team made up of developers and IT department staff to set up the concept for test and production environments.
Training for IT and developers is available from the vendor, or if you organize in-house training from the vendor partner. Provisioning of data should be the responsibility of the IT department. You can also plan to have the vendor or vendor partner implement the product.
What was our ROI?
The vendor offers multiple possibilities for getting started with QlikView. It also depends upon how many reports you need for initial go-live. Starting with the Small Business Edition or Enterprise depends on the company size and the number of users who will work with QlikView.
What other advice do I have?
The only important advice is to take enough time for the concept of the future environment.
That will make it easy to implement all needed add-ons with future changes.
Follow the vendor’s suggestions for scale responsibilities (IT, developer, designer and end user).
The Qlik user forum will be always helpful to find a solution.
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.
Director of Development at a manufacturing company with 51-200 employees
Big Data – Qlikview (Allies or Foes)
“Big Data” as it is generally defined as:
A large voluminous, fast changing, multi-structured dataset, generally distributed in nature, non-EDW compliant (mix of RDBMS/non-RDBMS) dataset
Due to the nature and flow of data, it has associated issues and complexities like performance, governance and analytics etc…
In general discussions, “Big Data” term is generally used analogous to Hadoop infrastructure, but in this discussion, we will assume Big Data as a principle rather than a current technology/solution.
“Qlikview” on other hand, is In-memory Business Intelligence Solution able to handle very large datasets and advocates its user friendliness and intuitiveness, shorter development cycles and analytical capabilities among other things…
Now once, Big Data/Qlikview introduction is clear, let’s see these two bit closely and together
Following charts generally lists 3 aspects of Qlikview/Big Data
|
Big Data |
Qlikview |
|
Configuration |
Distributed |
It is distributed in nature… |
Traditionally Single instance of Qlikview Application is |
Properties |
Volume |
Very large Volume (terabytes or more) |
Large Volume (20-100 of Gigabytes is not unheard of) |
Velocity |
Data speed is varied, based on operation… Click Stream data, RFID data is real time |
Data Frequency(speed) is generally mini-batch with small delays |
|
Data is generally pre-defined datatype, and most of datasets in general occurrence is Date, text, numbers etc. |
|||
Implication |
System |
Generally data is large for a single DB/Filesystem to handle, so data is generally distributed across a number of systems. |
Generally data from multiple datasets, since memory based, it is limited by max memory applicable on server |
Data Relationship |
Dataset is traditionally non-EDW (images/videos/blogs/web logs etc) |
Generally a Dimensional model |
|
With big data comes, problems like performance, management and analytics. |
In memory solution, allow fast performant reporting and analytics user response |
Quite obvious there are number of ways, where the systems are designed differently and surely for different purposes, Does it make Qlikview and Big Data as non-compatible solutions or two applications with own strengths and perfect partners when used in conjunction can deliver solution the business needs?
The answer of this question lies in answering the bigger question… “What does business wants and what does IT have?”
With more and more mountain of information flowing in and new nomenclature becoming more common in regularly use. (Mega/Giga/Tera) being now replaced by (Peta/Exa/Zetta). New technologies and more processing power coming to fore, surely underlining the validity of Moore’s law.
What is more important is not what this data holds, but what useful or relevant information it has and which can be used efficiently. Information is Gold; it has to be treated that way. But while looking at information, we need to understand and look at another analogy, which comes from mining of precious metals. While searching for Gold, it is not like that miners find the strips of Gold and they don’t. It is more likely that Gold may not be visible to naked eye and need sophisticated processes to find and process Gold. A terminology Strip Ratio (1 ppm for Gold) defines amount of waste need to be processed to find area of your interest
So new technologies allow exposure to more and more data with different “strip ratio” and to make it as information, as John mentioned in this article Qlikview and Big Data: It’s all about Relevance. The information is about relevance, having more and more information on users desk or computer, will not make users any more capable and knowledgeable and geared toward making right decisions, but what is needed, an organized, structured view on that information set, where information which is relevant to the user is presented in way, the user can utilize.
Major critics of In-memory based solution generally come out with this argument – “Memory/Hardware/OS Limitation” and hence its (Qlikview) in-ability to handle this Big Data in single application.
Picking the comparison from Big Data itself, technical reasons were governing reason of distributed nature and Architecture of Big Data.
I see no surprise if same principle is applied across BI and Analytics with distributed Apps as answer to it, with Business driving the data distribution split rationale.
As ideally Business doesn’t need a single application, showing them universe of data, but wanted to see the data of their universe in single forum, so on top of well distributed dataset, there can be array of Qlikview apps serving specific business needs or drive.
So revamping some of the definitions:
Hadoop (HDFS) – Data is being global, distributed and varied and large, it is split into multiple subsets, location and copies for multiple usage…
Qlikview (BI) – Information is being global, distributed and varied and large, it is split into multiple apps, location and copies for multiple usage…
The new world order
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Works at Toccato Tecnologia em Sistemas
For the first time, they were able to analyze consistent data
What is our primary use case?
I developed an application for a hospital to improve the potential of analysis of that company. I used Windows Server 2008, 8Gb RAM, two processors.
How has it helped my organization?
The hospital improved the quality of the data analysis and increased its profits, because, for the first time, they were able to analyze consistent data.
What is most valuable?
- Speed of development
- Ease of learning
- Low ROI
- Fast deliveries
- Scalability
- Multiplatform, and speed in queries.
What needs improvement?
- Improvement in the graphical user interface
- Introducing HTML 5
- Context sensitive
- Drag and drop visualization
- Responsive design.
For how long have I used the solution?
More than five years.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Senior Manager at a consultancy with 10,001+ employees
The associative engine and feature-rich expression scripts are the most valuable features of this product.
What is most valuable?
The associative engine and feature-rich expression scripts are the most valuable features of this product.
How has it helped my organization?
Easy, low-TCO solution to consolidate and visualise data for analysis and reporting purposes.
It provides better visibility of the company's position and its operations.
What needs improvement?
I would like to see more visualisation objects features.
For how long have I used the solution?
I have used QlikView for more than a year.
What was my experience with deployment of the solution?
I encountered minimal deployment issues.
How are customer service and technical support?
Technical support is excellent.
Which solution did I use previously and why did I switch?
I have experience with other similar visualizers, but QV offers a better experience in terms of ETL development.
How was the initial setup?
Initial setup was straightforward, with a simple, easy interface. We had a simple setup anyway, not much complexity. We were able to get QV up and running in a very short turnaround time.
What about the implementation team?
It was implemented in-house assisted by a lean vendor advisory team.
Disclosure: My company has a business relationship with this vendor other than being a customer: We are also an SI partner.
Senior BI Consultant (Qlikview) at a tech services company with 51-200 employees
KPI uniformity across all departments has improved problem-solving efficiency.
What is most valuable?
- The way data is loaded, transformed and stored in one single file with a high compression rate
- The development flexibility allowing almost any type of relationship between data from disparate sources
How has it helped my organization?
Uniformization of KPIs across all departments brings efficacy and effectiveness to coworkers in problem solving.
What needs improvement?
Performance at front-end level could improve but usually there is a workaround - by reducing application size, splitting applications or the way the UI is presented - without affecting user experience.
For how long have I used the solution?
I have used it for two years.
What do I think about the stability of the solution?
There can be issues in terms of stability during usage peeks. In these situations, the server can experience short down times. Again, many of these situations can be prevented by using the best development methodologies.
How are customer service and technical support?
Technical support is very good. They are always available on providing guidelines.
Which solution did I use previously and why did I switch?
There are other data visualization tools similar to QlikView. Spotfire, for example, has incredible UI possibilities, but I think QlikView is very ahead in the competition in terms of solution flexibility.
How was the initial setup?
QlikView setup is very straightforward, only requiring server parameterization in terms of ODBC and the QlikView Server. It is not complex when compared to similar products.
What about the implementation team?
It was implemented by an in-house team; some persons on the team had previous experience with QlikView. The learning curve is very quick, but the best practices provided by Qlik must be followed from the beginning of implementing the QlikView architecture.
What other advice do I have?
Due to the quick development of QlikView applications, best practices cannot be disregarded. (For example, load only fields/tables that users need to be available in the application’s layout. When the number of applications starts to increase, this can seriously affect user.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Project Manager at a logistics company with 51-200 employees
We now have set up and shared dashboards across our services. Not all the features are available for Mac users.
What is most valuable?
Dynamic dashboards is definitely the most valuable feature. You select your filters and all your graphs and tables are automatically updated; it really saves time when doing analysis!
How has it helped my organization?
Thanks to Qlikview we have been able to set up and share dashboards across our services. We can monitor our internal productivity and revenue, but as well our client’s activity and be proactive if we see a sudden change in volumes. We also monitor our service levels.
Qlikview is giving visibility to our directors and VP , accounts department, as well as operational managers who can follow on their teams productivity.
What needs improvement?
Qlikview is very intuitive and user friendly compared to other solutions, however I regret that some of their features are not available for Mac users.
A build your own report feature on standard .qvw would be great. Qlik has recently launched Qliksense, it answers this need but we cannot use the Qliksense feature on Qlikview reports. An all-in-one solution would be perfect.
For how long have I used the solution?
Since 2008
What was my experience with deployment of the solution?
Initial database set up was the main concern.
How are customer service and technical support?
Customer Service is good, however we mainly use the Qlikview community. We can reach out to other users / developers who are always available to help.
Which solution did I use previously and why did I switch?
Before Qlikview we had 2 BI solutions : Cognos and Hummingbird. Hummingbird was more a database extraction tool available for our clients. We then developed our own operational web-based database for our clients to check their transportation invoices and extract instantly the data they needed for reporting purposes. When this solution was live and operational we stopped Hummingbird as it did not make any sense to maintain both solutions.
In parallel, Cognos was our BI tool for dashboards/ graphs. We decided to change to Qlikview since Cognos was more complex in terms of development and less user friendly.
How was the initial setup?
I would say straightforward. Training was provided by our supplier, and our developers already had BI knowledge .
What about the implementation team?
Our vendor (Decideis) helped us with the initial set up and training; we then deployed the solution ourselves.
We are really happy with their knowledge of Qlikview.
Which other solutions did I evaluate?
Cognos was evaluated and Qlikview was highly recommended by one of our customers.
What other advice do I have?
Define precisely your needs, your budget and the resources available to set-up, deploy and maintain the solution. There are different solutions on the market, choose the one that will answer your needs.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Consultant at a tech services company with 51-200 employees
Presentation of data on a map and what-if modeling could be better, but its point and click user interface is valuable
What is most valuable?
The features of this product that are most valuable are: its point and click user interface, speed, ability to follow dependencies in data, ability to fix any view in my special sheet, ability to track back to data sources for any output value or part of a graph.
How has it helped my organization?
We implemented an application for control of sales team, for controlling. Accounting people or our sales director are able to work with it without extensive training and they are able to do their own analysis without support of IT people. We developed an application for health insurance company that allows them better control of a cost paid to hospitals or doctors. They have very detailed analysis of drugs paid by insurance.
What needs improvement?
Areas of this product with room for improvement are ETL, presentation of data on a map, what-if modeling or predictive modeling, license policy.
For how long have I used the solution?
We are using it for, I think, 6 years.
What was my experience with deployment of the solution?
No. But you should respect such special features when you design a data model.
What do I think about the stability of the solution?
No issues with stability.
What do I think about the scalability of the solution?
No. But we did not used QlikView for Big data.
How are customer service and technical support?
Customer Service: The customer service is done by partners. So if you have knowledgeable partner the service is good, if not you can easily switch to another. Our country is small and there are several partners who can support QlikView, so I think that every customer could receive good support.Technical Support: Technical support from QlikTech is at standard level. What is non-standard in a comparison with other tools is the very low number of errors that we found. I do not remember any important error during the time we used it.
Which solution did I use previously and why did I switch?
We used Microstrategy, Actuate, Crystal Reports. Microstrategy was much slower (all of them) and it had very bad support in our country. All three tools consumed much more days for building the applications – but it was 5-6 years ago, I am not familiar with today’s versions.
How was the initial setup?
It was straightforward, but we have skilled people and we are not beginners. We are an IT company.
What about the implementation team?
We did implementation in-house and we deliver projects for our clients. We have people that passed training in QlikTech.
What's my experience with pricing, setup cost, and licensing?
Day to day cost consists from maintenance fee and we have a man, who is responsible for development of the internal application. But the same man together with other members of BI team are working for the customers. Setup cost was not high. When we started we bought 5 licenses and developed the application in-house, but during the years we have invested in the development of our internal applications. It is a continuous improvement.
Which other solutions did I evaluate?
We have knowledge of Microsoft Analysis Services, Jaspersoft. We sometimes use Jaspersoft as an embedded reporting tool into application. QlikView was nice and easily to learn, so the evaluation period was short.
What other advice do I have?
To do careful requirements analysis, be sure that you have all relevant data available, start the project with somebody, who has an opinion of QlikView.
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?
Have you evaluated other tools? What made you chose Qlikview over anything else?
Note: I work with DataRPM and just curious to know your thought process / budgets - whatever you can share.