Qlik: Useful and Handy BI Tool
We use it in our organization in order to have a trend analysis to improve product decisions. QlikView helps our sales team analyze …
QlikView
Top Rated
QlikView
Top Rated
QlikView
Overview
What is QlikView?
QlikView® is Qlik®’s original BI offering designed primarily for shared business intelligence reports and data visualizations. It offers guided exploration and discovery, collaborative analytics for sharing insight, and agile development and deployment.
Read moreRecent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Top Rated
2022
Popular Features
View all 20 features- Customizable dashboards (62)8.787%
- Drill-down analysis (62)8.181%
- Report sharing and collaboration (59)8.181%
- Formatting capabilities (63)7.777%
Video Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of QlikView, and make your voice heard!
Pricing
View all pricingQlikView
Custom
On Premise
per user
Entry-level set up fee?
- Setup fee optional
For the latest information on pricing, visithttp://www.qlik.com/us/search?q=pricing…
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Features
Return to navigation
Product Details
- About
- Competitors
- Tech Details
- Downloadables
- FAQs
What is QlikView?
The vendor describes QlikView, Qlik’s classic analytics solution, as a revolution in how organizations use data, with intuitive visual discovery that put business intelligence in the hands of more people than ever. Qlik Sense, the vendor's next-generation analytics platform, supports the full range of modern analytics use cases at enterprise scale by combining the Associative Engine with Cognitive Engine driving augmented intelligence, plus a scalable, governed cloud architecture.
As businesses modernize operational processes including BI, Qlik Sense is provided by the vendor as the way forward. Through the Qlik Analytics Modernization Program, QlikView users can adopt Qlik Sense at their own pace for a small uplift on their annual maintenance rate -- which they state will expand an enterprise's analytic possibilities while reducing the total cost of ownership for BI.
QlikView Features
BI Platform Features
- Supported: Administration via Windows App
- Supported: Administration via MacOS App
- Supported: Administration via Web Interface
- Supported: Live Connection to External Data
- Supported: Snapshot of External Data
- Supported: In-memory data model
- Supported: OLAP (Pre-processed cube representation)
- Supported: ROLAP (SQL-layer querying)
- Supported: Multi-Data Source Reporting (Blending)
- Supported: Data warehouse / dictionary layer
- Supported: ETL Capability
- Supported: ETL Scheduler
Supported Data Sources Features
- Supported: MS Excel Workbooks
- Supported: Text Files (CSV, etc)
- Supported: Oracle
- Supported: MS SQL Server
- Supported: IBM DB2
- Supported: Postgres
- Supported: MySQL
- Supported: ODBC
- Supported: Cloudera Hadoop
- Supported: Hortonworks Hadoop
- Supported: EMC Greenplum
- Supported: IBM Netezza
- Supported: HP Vertica
- Supported: ParAccel
- Supported: SAP Hana
- Supported: Teradata
- Supported: Sage 500
- Supported: Salesforce
- Supported: SAP
- Supported: Google Analytics
BI Standard Reporting Features
- Supported: Pixel Perfect reports
- Supported: Customizable dashboards
- Supported: Report Formatting Templates
Ad-hoc Reporting Features
- Supported: Drill-down analysis
- Supported: Formatting capabilities
- Supported: Integration with R or other statistical packages
- Supported: Report sharing and collaboration
Report Output and Scheduling Features
- Supported: Publish to Web
- Supported: Publish to PDF
- Supported: Output Raw Supporting Data
- Supported: Report Versioning
- Supported: Report Delivery Scheduling
Data Discovery and Visualization Features
- Supported: Pre-built visualization formats (heatmaps, scatter plots etc.)
- Supported: Location Analytics / Geographic Visualization
- Supported: Support for Machine Learning models
- Supported: Pattern Recognition and Data Mining
- Supported: Integration with R or other statistical packages
Access Control and Security Features
- Supported: Multi-User Support (named login)
- Supported: Role-Based Security Model
- Supported: Multiple Access Permission Levels (Create, Read, Delete)
- Supported: Report-Level Access Control
- Supported: Table-Level Access Control (BI-layer)
- Supported: Field-Level Access Control (BI-layer)
Mobile Capabilities Features
- Supported: Responsive Design for Web Access
- Supported: Mobile Application
- Supported: Dashboard / Report / Visualization Interactivity on Mobile
QlikView Screenshots
QlikView Videos
Qlik Analytics Modernization Program Overview
QlikView Competitors
- Tableau Server
- Domo
- Microsoft PowerBI
QlikView Technical Details
| Deployment Types | On-premise, Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Windows, Linux, Mac |
| Mobile Application | Apple iOS, Android, Windows Phone, Blackberry, Mobile Web |
| Supported Countries | Americas, EMEA, APAC |
QlikView Downloadables
Frequently Asked Questions
QlikView® is Qlik®’s original BI offering designed primarily for shared business intelligence reports and data visualizations. It offers guided exploration and discovery, collaborative analytics for sharing insight, and agile development and deployment.
Tableau Server and Domo are common alternatives for QlikView.
Reviewers rate Pixel Perfect reports highest, with a score of 8.8.
The most common users of QlikView are from Enterprises (1,001+ employees).
Comparisons
View all alternativesCompare with
Reviews and Ratings
(786)
Attribute Ratings
Reviews
(1-5 of 5)- Popular Filters
Companies can't remove reviews or game the system. Here's why
May 24, 2016
QlikView Positive Review
We are using QlikView as part of the reporting strategy at the university. Dashboards are being developed for different entities within the university and each entity is using it for its own purpose. We created dashboards to reflect the students' status and behavior, the status of the IT ticketing system and the status of the financial situation. The plan is for us to use QlikView now with the new data warehouse we're building to be able to report on the whole situation of the university from one source.
- Fast applying changes to the filters
- Easy to deploy and needs minimal operation time
- It connects to all data sources we needed
- The online community is very helpful and it has a lot of data already
- The Select Tables form needs major renovations
- Still has stability issues where it crashes frequently
I haven't used a different BI solution other than QlikView. This makes me in a position where I'm unable to make a comparison
N/A
N/A
N/A
N/A
60%
6.0
76.66666666666667%
7.7
N/A
N/A
45%
4.5
N/A
N/A
60%
6.0
N/A
N/A
50
Student Admission
Advancement
Helpdesk Managers
IT Managers
Student Services
Advancement
Helpdesk Managers
IT Managers
Student Services
2
We have one designer/developer and one system admin available in-house to support QlikView.
The designer/developer usually handles the clients' request and maintaining the QV dashboards.
The system admin handles the QV server, handling permissions, licencing and monitoring.
The designer/developer usually handles the clients' request and maintaining the QV dashboards.
The system admin handles the QV server, handling permissions, licencing and monitoring.
- Vendor implemented
November 12, 2015
Click to view! No waiting in Qlikview.
Score 10 out of 10
Vetted Review
Verified User
It is being used across the entire Company (in a BPO environment) for different customers, mostly for scorecards and finance analysis dashboards.
- One of the main strengths I always bring up is the associative technology, which is the Green-Gray-White concept. This Qlikview functionality brings more intuitiveness to the applications in a very natural and efficient way.
- In-memory technology brings very quick and easy switching between field value selections, since ALL the data is stored in the RAM. Information is already available on click. This is very advantageous particularly for customers not very fond of the usual 'enter parameters, run report and wait 5 mins or so'.
- Ease of design and development. Qlikview can be as simple as creating reports in Excel, with minimal training, but at the same time seasoned developers can utilize technical and complex functionalities to bring out the most efficient methods and deliver difficult requirements.
- Availability for a mobile and tablet version of the application without additional development required. Everything is done by the server.
- Qlikview can be used 'on top' of other BI tools, much like Excel is usually used as the final presentation for reports.
- In-memory technology requires large amounts of RAM, and real-time data availability is not possible. Data is only limited to the last reload or refresh of the application.
- A corporate complaint I always hear: Expensive Licenses. Perhaps this can be remedied by having more variations.
- Not really a weakness, but for non-technical users looking to develop applications, a level of familiarity of proper data modeling and design techniques are needed to ensure information accuracy.
- Client is only available for Microsoft Windows systems, so development is only limited to that. Nonetheless the users may access the application using any platform with a web browser.
- IBM Cognos,Salesforce.com,ServiceNow,MS SharePoint / SQL,Crystal Reports,Microsoft Access
Qlikview has a distinct advantage with in-memory and associative technologies.
N/A
N/A
N/A
N/A
83.33333333333334%
8.3
55%
5.5
75%
7.5
66.66666666666667%
6.7
56.66666666666667%
5.7
55%
5.5
N/A
N/A
November 11, 2015
Choosing the Right BI Reporting Platform
QlikView is our companies go-to reporting solution. It is our frontend BI tool and is generally used to pull information out of our database. We provide a flexible "report builder" which is valuable to our end users who build reports off QlikView reports. This reporting tool is used across many departments: SEM | BD | Partners | SplitTest | Finance
- Fast - everything is in memory so it moves away from the traditional logistics of reading data from disc.
- Interface is fast to develop. Once a thoughtful data model is setup. The frontend development is fast and allows a RAD environment.
- The server itself is easy to maintain. Maintenance is low and does not need a typical "sys admin" to manage this reporting server
- Visualization - Graphically beautiful and provides that "bells and whistle" factor
- The relationship of how data models are put together in QlikView - it requires good level of technical understanding how models are put together. If they had an ERD like framework when opening up an existing dashboard it would be helpful.
- The licensing model QlikView employs financially does not make sense for growing small companies.
- The support of AJAX technology is not up to par with its predecessor, IE plugin. They could do much better job implementing the same features in IE plugin over to AJAX users. The migration will be much simpler since AJAX will be the standard under Qlikview's new future versions.
I have used CrystalReports XI, and SSRS 2005. Both are similar to one another but uniquely different from Qlikview. QlikView provides unique way of taking a subset of a filtered data model and creating another model in memory and comparing it to one another. I don't know of any other tools that allows this powerful type of analysis.
Also the speed of QlikView is much faster. The amount of data I'm dealing with is close to 100M records. We have one dashboard as large as 2GB fully compressed and is very fast in pulling detailed information.
Also the speed of QlikView is much faster. The amount of data I'm dealing with is close to 100M records. We have one dashboard as large as 2GB fully compressed and is very fast in pulling detailed information.
N/A
N/A
N/A
N/A
90%
9.0
90%
9.0
100%
10.0
80%
8.0
66.66666666666667%
6.7
95%
9.5
N/A
N/A
1
0
- Vendor implemented
- Professional services company
We were early adopters. Don't remember who but it was 3rfs party help.
Change management was a major issue with the implementation
June 27, 2013
QlikView - Jive Analytics
Score 9 out of 10
Vetted Review
Verified User
- Extremely fast data visualization. We can go from a high level view to the most granular detail in seconds.
- Associative search -- there are no pre-defined drill paths. You can visually explore the data and go anywhere you want. You do not have to drill down...and then back up. It makes the data exploration much easier.
- Very strong data loading capabilities.
- QlikView is really a platform that you can extend. You can incorporate it into web pages, integrate it with the R open source engine, build custom extensions, etc.
- QlikView has a "green, white, grey" color scheme. Green is what I selected, white is what is included in that data set, and grey is what is excluded. It is a powerful visualization tool that can show you what is included as well as what is excluded. For data junkies, it is an excellent tool.
- If you are looking to analyze real-time data, QlikView is probably not the right tool for you. It uses static pre-loaded data, rather than live data from an external data source.
- We can literally do in a few minutes what it would have taken us hours or days to do in the prior Business Objects tool. We can quickly get to detailed information to see what is happening in our community, who the power users are, what they are doing, activity trends, etc. We then use these insights to determine any changes we want to make in our user adoption strategies.
2
This question doesn't necessarily apply. We've built an application using QlikView that we use with our clients. Our clients have various numbers of users on the platform.
1
Technology savvy individuals.
- Our primary use is analyzing millions of rows of social collaboration activity.
We created an application using QlikView that is a replacement for Business Objects.
TIBCO Spotfire and Tableau were other systems considered. Both of these products are very good and they all have different strengths. QlikView best met our business needs because of its ability to load multiple data sources directly, handle ETL logic on the data load, delivers to mobile devices via HTML5, and its ease of data visualization.
- Implemented in-house
- Professional services company
We implemented in house on our own and work with our customers on implementations.
- Self-taught
It depends on what you are going to do. For the high end users, training would certainly shorten the learning curve.
We did not do any custom coding to the platform. It is all out of the box.
No
Not necessary in our deployment.
- Jive Software
The integration was simple. We connected QlikView to Jive's analytics database and were up and running in no time.
- We likely will integrate with Active Directory and Google Analytics in the future.
Yes
November 13, 2012
Incredibly fast in-memory model.
Score 8 out of 10
Vetted Review
Verified User
- Self-service
- In-memory performance
- Associative model
- Their UI from a development perspective, for developing dashboards.
- A lot of the components that you can place on a dashboard, i.e. filters, sliders etc. are handy
- You can spit out to Excel, PDF.
- Out of the box, the governance and meta data management is not great. You can buy another product for that. Out of the box, you can get yourself in trouble. We have solved for that through business process and workflow.
- They are still a bit tied too Microsoft tools like Internet Explorer. Working on Firefox, Chrome, Safari is not the same experience. We would really like them adapt. For example, when viewing a line graph with multiple points on graph, if you zoom over a point, it will light up the bubble in IE, but we cannot get it to work the same way in other browsers.
- Performance tuning explain plans don’t exist.
- Our ability to do custom Ajax development – we would like to put in a widget, where we can do an uptime call and have nothing else change. No documentation etc.
- Documentation is ok.
- Speed to market is the really big thing. You can attach to multiple data sources quickly and build a consumable model for a dashboard. It doesn’t require IT talent to build. We have built more dashboards and added more users in the last year, then in our entire history. I was at a company of 30k+ employees before, and we didn't have near this level of BI adoption.
- As a result, we are seeing benefits across business function. For example, within sales, our pipeline has much more visibility. It allows for much faster decisions on things like quotas. One of our biggest power users is in sales ops. She feels her dashboards load 10x faster than our previous tool and she can make changes on the fly.
200
We have 200 people/ day use the software as end users consuming dashboards/reports. It encompasses almost every department in our enterprise – cloud, sales, support, finance, accounting, security, procurement/supply chain, IT. It is truly distributed.
Since starting use, we have had more than half the company – 2800+ unique people use the system as some point. It is the most adopted BI tool I have ever implemented.
In total we have 40-50 power users building models in the system, again distributed across business functions. Those power users are supported by 1-2 people in my department, IT. We have a tight nit relationship with our power users. Our users can build their own QVDs – models. Now to get them into production, we (IT) review them to make sure they are not duplicating existing models, and not doing something that QVD is not meant to do. We also tune them to the best degree we can as a bad dashboard can slowdown the system. I will say that QlikView's monitoring consoles are very cool. We can see the top running queries, unique users, and the trending of consumption of dashboards.
We (IT) do two training classes month - one for basic usage, and one for power users, building models in the system.
1.5
We have 1-2 people in the IT department in governance roles. They were BI developers previously.
We have 40-50 power users in the business.
- Data visualization/ reporting for multiple aspects of our operations including sales, marketing, service, procurement, finance and IT.
SSRS – Microsoft Report Services
Our shortlist included Tableau, a newer version of Microsoft's SSRS and Qlikview.
We also knew what Micro Strategies and Business Objects had to offer from our experiences with them at other companies, and knew what we could afford. We eliminated them on price and the complexity of set-up.
We liked QlikView's in memory, associative model, and self-service capability.
With "in-memory", everything that gets consumed from a dashboard is loaded in memory so it is incredibly fast. Although Qlik touts its mobile distribution capabilities, that was not a huge differentiator for us, but is something we are now exploring. Microsoft and and BO do have in-memory capabilities now.
The associative model is patented by QlikView. Basically it starts to understand the associations in your data, e.g. if A=B and B=C, then A=C. It means you can build a Qlikview model very quickly. In traditional data warehousing, you work with users and understand their requirements, refine the data model, start to physicalize it, tune it, build ETLs. It's a 3 month at best delivery cycle. That doesn’t work here at this company. Our business users will not wait for you. Our business is dynamic, we are launching new products all the time. Instead of going through an arduous process, you just load data into QlikView and build an associative model. It link things up. If it doesn’t work, you can change things very quickly. You don’t have to write data definitional language. Where you get into trouble, is if you load very large data sets into QlikView, memory not as abundant. They are releasing a tool called data explorer which allows you to do a hybrid approach – load some in memory and some in database. If data is going into frequently used dashboards it goes into memory. If infrequent access is required and the data set is very large, it makes sense to leave it in the database.
We also have a company called DataRoket that builds connectors for us, e.g. load this relational data into QlikView. They have built adapters for QlikView-Hadoop integration.
- Vendor implemented
- In-person training
- Self-taught
My team holds training sessions for our internal users every month. 8-10 of our staff attend each month. We have an intro class, and a power user class.
No
- Various databases/ data containers including Oracle, SQL Server, Cassandra (which we use for time series event data, monitoring). We do not integrate directly to operational systems, e.g. for finance, CRM, but push data from those enterprise apps into a data layer, so that we're not taxing those operational systems with queries. We have also built a star schema data mart for the cloud.
It was pretty simple to achieve via ANSI SQL adapter, ODBC.
QlikView also hasa 3rd party building data adapters from different systems like Hadoop.
We use Informatica to pull data from operational systems into the data layer.
Make sure you do a bake-off to compare Tableau and other best in class systems like Microsoft, PowerPivot.
Really understand their license modeling as it’s changed. They didn’t have enterprise licensing model when they started. You really need to think about the taxonomy of your users. For example, power user licenses are different from end-user.
You also need to understand concurrency.