We use QlikView for business analytics, primarily for internal insights in the healthcare space.
Software Engineer I at a healthcare company with 1,001-5,000 employees
Associative model simplifies analytics, but enhanced modeling capabilities needed
Pros and Cons
- "The initial setup is straightforward."
- "QlikView is probably on the pricier side than other BI tools."
What is our primary use case?
What is most valuable?
QlikView employs the Snowflake schema, which becomes an associative model, making it easier to drive insights. Additionally, the intensity with which you can work on the ETLs is quite impressive.
What needs improvement?
Creating an out-of-the-box solution for modeling capabilities might be beneficial.
For how long have I used the solution?
I have used QlikView for about a year.
Buyer's Guide
QlikView
October 2024
Learn what your peers think about QlikView. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,649 professionals have used our research since 2012.
How are customer service and support?
I didn't really face any big challenges with technical support; it depends on the plan. I am not a hundred percent sure.
How would you rate customer service and support?
Neutral
How was the initial setup?
The initial setup is straightforward. I would rate it around a seven out of ten in terms of ease.
What about the implementation team?
Approximately four people were involved in the deployment, though I joined the tool for a short period and am not entirely certain about the current team composition for maintenance.
What's my experience with pricing, setup cost, and licensing?
QlikView is probably on the pricier side than other BI tools. It's more expensive than the overall implementation of Power BI and maybe about or a little less than Tableau. I do not have any specific numbers regarding the cost.
Which other solutions did I evaluate?
We use other BI tools like Tableau, Power BI, R, and Python.
What other advice do I have?
QlikView's overall product could be enhanced with a bit of finish.
I'd rate the solution seven out of ten.
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.
Last updated: Oct 8, 2024
Flag as inappropriateFSI IT Consulting Manager at Deloitte Portugal
As long as its back end data model is well designed, it is intuitive.
What is most valuable?
The strongest characteristics of the product are its ease of use and its data discovery and exploration capabilities:
- Ease of use, as it is very intuitive, as long as its back end data model is well designed, providing its end users with a high level of autonomy and the developers with a very intuitive and complete set of tools.
- Data discovery and exploration, thanks to its in-memory data association capabilities that provide a fast and easy way to relate and explore data.
How has it helped my organization?
As a consultant, QlikView has helped me deliver high-value BI solutions to my customers, consistently exceeding their expectations and creating new opportunities for my firm.
What needs improvement?
It could be more mobile friendly, as some of its features don’t work properly on mobile devices or do not provide the best user experience to our customers who would like to extend their access to data. A Cortana/Siri-like feature or advanced analytical capabilities for users with advanced scripting and statistical skills would also extend its usage in the organizations where I operate.
For how long have I used the solution?
I have been working with QlikView for about 4 years.
What was my experience with deployment of the solution?
I still find some fine tuning issues when scaling up in concurrent usage or data volumes.
How are customer service and technical support?
Strong customer service, not as strong on the technical part, and the community is still a bit underdeveloped.
Which solution did I use previously and why did I switch?
I’ve also worked with other main market solutions like Microsoft, or Tableau, but over the last few years, QlikView has evolved considerably, especially when they completed it’s offering with Qlik Sense 2. Although it is not as versatile as the Microsoft solutions, it is stronger in ease of use and development when compared to Power BI for example. It’s licensing costs when compared to Tableau are also a differentiating factor.
How was the initial setup?
It was extremely simple and straightforward to implement.
What about the implementation team?
We do our own implementations without the need for a high level of involvement from the QlikTech vendor team. Our main advice is that a good understanding of how tabular models work when designing the data model, and a good understanding of the full QlikView offering specifically in terms of ETL, are fundamental for a good QlikView implementation project.
What was our ROI?
BI implementation projects using QlikView are normally faster to execute and faster to get the customer to perceive its value. However, it makes sense to start with a smaller investment specifically on QlikView licensing, as modeling the data and implementing the ETL part is still the biggest bottleneck. It doesn’t make any sense doing a big investment in user licensing, when the real use of QlikView still depends on getting the data to make sense.
What other advice do I have?
Make sure you have your data straight - think like Kimball, but act like Inmon - before moving to QlikView.
Disclosure: My company has a business relationship with this vendor other than being a customer: My company is a Qlik partner.
Buyer's Guide
QlikView
October 2024
Learn what your peers think about QlikView. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,649 professionals have used our research since 2012.
Business Intelligence Latin America Leader at a engineering company with 1,001-5,000 employees
Once you select data on the dashboard, it highlights the unavailable data in order to show that those combinations don’t exist or aren’t possible.
What is most valuable?
Once you select any data on the dashboard, QlikView highlights the unavailable data in grey in order to show to users that those combinations don’t exist or aren’t possible.
Filters are not local. Once you filter something, the standard is to apply the filter to all tabs available in the dashboard.
How has it helped my organization?
They used to manage the business data through spreadsheets, now they have an automates process and a stable solution. It reduced to zero the time to prepare the data, avoiding operational issues and allowing them to put all the focus on business analysis.
What needs improvement?
Qlikview should have a connector or a specific product to allow people outside of the company or that don’t have a license to read/use the application (a kind of reader license). At least something really cheaper or free.
For how long have I used the solution?
I have used QlikView for three years.
What was my experience with deployment of the solution?
I have not yet encountered any issues with deployment, stability or scalability.
How are customer service and technical support?
I rate technical support 8/10.
Which solution did I use previously and why did I switch?
The time or effort to develop new stuff in QlikView is lower than other traditional tools as MicroStrategy, Cognos, etc. Besides that, we are changing our approach to a self-service BI.
How was the initial setup?
The initial setup was straightforward. QlikView allows you to install it on regular desktops with 8 GB memory. After some time, we migrated QlikView to a server with 64 GB, due to the number of users and the amount of applications developed.
What about the implementation team?
We implemented/developed with an in-house approach.
I would advise that the first implementation should be done through a vendor team in order to have better standards/best practices applied from the beginning. It would speed up the learning curve.
What was our ROI?
For this specific case, we didn’t calculate or estimate the ROI. Comparing QlikView to Tableau, I think that Tableau has a more attractive pricing/licensing approach than QlikView. I would recommend studying it before starting to acquire new licenses in QlikView due to the model of sales (Named Call and Document Call). The cost of new licenses could increase faster if you don’t have in mind the proper usage.
What other advice do I have?
Qlikview has a huge community in the internet with a lot of examples, online course, etc. It will help a lot to test by yourself. I would recommend providing a POC among the tools to identify which of them would fulfill your needs better.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Senior IT Project Manager at a financial services firm with 10,001+ employees
SQL scripting provides the fastest way to pull data into the system.
What is most valuable?
SQL scripting, as it provides me the fastest way to pull data into the system, since I’m more on the technical side.
How has it helped my organization?
It has made our processes for collecting and presenting data easier, especially with regard to old spreadsheet mentalities.
What needs improvement?
Their marketing department is heavy-handed, more so than it really needs to be. This can turn companies off when they get too aggressive. Their pricing structure doesn’t match their aggressiveness either, costing an end user $1500 for a web-based license.
For how long have I used the solution?
I have been using QlikView for about 11 months.
What was my experience with deployment of the solution?
Their set criteria is a mystery of legends. I still, after a year, need to pull up a wizard to type up a set expression. It’s not intuitive at all.
How are customer service and technical support?
Technical support is very good, with an exceptional user base. I’m largely self-taught on Qlik because of their community and the breadth of their support on-line.
Which solution did I use previously and why did I switch?
I previously used Microsoft BI tools, but as a company we were too far behind the curve to take advantage of their latest technology in the BI space. Upgrading to Office 2016 is not something a Fortune 500 company is going to do overnight.
How was the initial setup?
The desktop component was straightforward. I didn’t set up the server component, so I can’t speak to the publishing.
What about the implementation team?
An in-house team performed the implementation.
What was our ROI?
No definitive ROI, but an enterprise license would go a long way towards adaptability and acceptance.
What other advice do I have?
QlikView and QlikSense are powerful tools that require IT and BI expertise to take full advantage of. True BI utilization is not just dragging fields and creating graphs. It requires deep knowledge of data utilization and visualization. Qlik can provide that, BUT at the cost of additional IT or BI expertise.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Logistics Engineer at a logistics company with 201-500 employees
An incredibly powerful tool that offers great scalability
Pros and Cons
- "QlikView is a scalable solution that multiple users can easily use."
- "QlikView certainly lacks in its ability to share visualizations or create visualizations easily."
What is our primary use case?
In my company, we use QlikView for dashboards. With QlikView, our company tries to ensure that we capture all operational items in the dashboard so that the management can take action based on that.
What is most valuable?
I think the main benefit of QlikView is that it is an incredibly powerful tool, as it can handle millions and millions of rows.
What needs improvement?
QlikView certainly lacks in its ability to share visualizations or create visualizations easily. QlikView is a powerful tool but has shortcomings when compared to the visualization capability provided by Qlik Sense or Power BI.
From my perspective, I understand that since QlikView is an older product, it can be simply left as it is, and users can move to Qlik Sense, which provides a much stronger visualization.
If QlikView decides that its visualization part should be just like Qlik Sense or Power BI, then I would say it would be too much to capture in one or two phrases, considering that it is overall much easier to create visually good-looking dashboards and also something like a geographical map which is not possible in to get in QlikView currently.
For how long have I used the solution?
I have been using QlikView for years. I am a user of the solution.
What do I think about the stability of the solution?
I am happy with QlikView's stability. Stability-wise, I rate the solution an eight out of ten.
What do I think about the scalability of the solution?
QlikView is a scalable solution that multiple users can easily use.
My company has 20 to 50 users of the solution.
How are customer service and support?
QlikView has a lot of resellers, and my company has been in touch with one of QlikView's resellers. It is QlikView's reseller and not the support from QlikView that my company contacts for help. I rate the technical support a seven out of ten.
How would you rate customer service and support?
Neutral
How was the initial setup?
The solution is deployed on an on-premises model.
What's my experience with pricing, setup cost, and licensing?
QlikView is a reasonably priced solution.
What other advice do I have?
I would suggest others to QlikView and go for Qlik Sense. Qlik Sense is a tool that is as powerful as QlikView with better visualization capabilities. I would not recommend anyone to use the older QlikView, but I would recommend anyone to move to Qlik Sense.
I rate the overall tool an eight out of ten.
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.
Director of IS at Bennington Marine, LLC
ETL, Integration, and Automation are made simple and help us to better understand our data
Pros and Cons
- "This solution has simplified getting to and understanding our data, no matter where it is housed."
- "This solution would be improved with the inclusion of a feature that would allow us to add a common library of (our) commands used in load scripts and expressions, so with a keyword, we would get a drop down to select the command we are looking for, as opposed to the generic help."
What is our primary use case?
We use this solution for ETL, Analytics, Reporting, Automation, Integration between data sources (cloud, local, spreadsheets, etc), Data Scrub for Migration to new software, and automation of sending files to banks instead of using EDI, Positive Pay, etc.
How has it helped my organization?
This solution has simplified getting to and understanding our data, no matter where it is housed.
What is most valuable?
The most valuable features are the ETL, automation, and ease of use by the user population.
What needs improvement?
This solution would be improved with the inclusion of a feature that would allow us to add a common library of (our) commands used in load scripts and expressions, so with a keyword, we would get a drop down to select the command we are looking for, as opposed to the generic help. I keep them all in OneNote now and copy and paste them in, then change the field names. This addition would really save time.
examples:
Convert date-time stamp to just a normal date in the Load script - so we can match to the company calendar for Model Year / month etc , Fiscal Year /month / week of year/ week in year
date(floor(DTTMSTAMP),'MM/DD/YYYY') as TransactionDate,
Storing QVD's: (this is the path needed from a Data Loader)
STORE SummarySalesAggregate INTO [..\QVDData\SummarySalesUnitsAndDollars.qvd];
Sorted and Count for creating Arrays:
SortedAndCounted:
Left join (SummarizeSales2)
LOAD
Option_Inv,
Line_No,
if(peek('Option_Inv',-1)<> Option_Inv,1, Peek('counter',-1)+1) as counter
Resident SummarizeSales2
Order by Option_Inv asc, Line_No asc;
For how long have I used the solution?
Since May 2013.
What do I think about the stability of the solution?
excellent
What do I think about the scalability of the solution?
excellent
How are customer service and technical support?
I have never worked with Qlik Customer Service directly.
Which solution did I use previously and why did I switch?
no
How was the initial setup?
it wasn't bad. We did need some consulting advise on the set up in the server...but designing the organization and naming conventions should be up to you. We took the consultants advise and ended up renaming, changing almost everything as far as naming conventions
What about the implementation team?
started with a consultant, didn't use them long.
What's my experience with pricing, setup cost, and licensing?
keep working with the Company to get the pricing you need.
Which other solutions did I evaluate?
yes - many
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Assistant Manager at KPMG Global Services (KGS)
I had the option to prepare data myself instead of always having to depend on the data team
Pros and Cons
- "I had the option to prepare data myself instead of always having to depend on the data team."
- "More/newer visualisation components need to be added."
What is our primary use case?
I have used QlikView to create powerful and compelling data visualisations. QlikView is a well-rounded tool with good visualisation component and data preparation features.
How has it helped my organization?
Using QlikView, we have been able to derive the value out of our data much faster than with other tools because of its easy to understand/use components and features.
What is most valuable?
As a developer, I liked that using QlikView, I had the option to prepare data myself instead of always depending on the data team.
What needs improvement?
More/newer visualisation components need to be added. QlikView's ability to embed custom visualisation is not a great experience.
For how long have I used the solution?
More than five years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Business Intelligence Director at a tech services company with 51-200 employees
In-memory analysis and the associative database queries are valuable features.
What is most valuable?
- In-memory analysis
- Associative database query
- Easy to use
- Easy to install
- Easy to maintain
How has it helped my organization?
Amazing fast response to complex business questions due to flexibility and easy to use.
We have increased our revenues by 30% because the rapid and effective insights provided with the analytics we built with Qlik.
What needs improvement?
I would like to see embedded predictive analytics models or more integration, connectors with advanced analytics platforms.
Qlikview is extremely good with descriptive analitycs. But when you need to predict using advanced predictive models like Logistic Regression or CART or decision trees, R and SAS institute for example are good at it, so if Qlikview would have this capabilities embedded or connectors to integrate with them will be a killer product.
For how long have I used the solution?
I have used it for nine years.
What do I think about the stability of the solution?
I have not encountered any stability issues.
What do I think about the scalability of the solution?
I have not encountered any scalability issues.
How are customer service and technical support?
Technical support is outstanding.
Which solution did I use previously and why did I switch?
I did not previously use a different solution.
What's my experience with pricing, setup cost, and licensing?
For the value you can add to your business, the TCO is low. There is a high price perception in the market, but this is relative.
If you do not take advantage of the solution, it definitely will look expensive but if you do, you will be happy.
Which other solutions did I evaluate?
For three months, we evaluated several solutions with installations provided by vendors such as Oracle BI, IBM Cognos, and SAP BusinessObjects.
The main challenge to prove during that phase was the ease of use without professional services support at that stage!!!
What other advice do I have?
I highly recommend this solution.
Disclosure: My company has a business relationship with this vendor other than being a customer: My company is an OEM partner for business solutions.
Buyer's Guide
Download our free QlikView Report and get advice and tips from experienced pros
sharing their opinions.
Updated: October 2024
Popular Comparisons
Microsoft Power BI
Splunk Enterprise Security
Databricks
Tableau
SQL Server
Amazon QuickSight
Alteryx
IBM Cognos
SAP Analytics Cloud
Qlik Sense
SAP BusinessObjects Business Intelligence Platform
Oracle OBIEE
Domo
SAS Visual Analytics
RapidMiner
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?
just used the REST connector for an API in the load script...worked excellent!