What users are saying about

QlikView

543 Ratings

Elasticsearch

84 Ratings

QlikView

543 Ratings
Score 7.7 out of 101

Elasticsearch

84 Ratings
Score 8.9 out of 101

Add comparison

Likelihood to Recommend

QlikView

QlikView is well suited for scenarios where a heavy data is involved or heterogeneous data is there which also requires some manipulation/ cleansing or application of business rules. Also, if the UI dashboard involves complicated formulas to be worked upon, QlikView is well suited.However, if there is a need to quickly create some dashboards where the developer has little knowledge on database/ scripting and also there is no data manipulation required for input data, other technologies other than QlikView can be considered.
No photo available

Elasticsearch

Elasticsearch is the gold standard for text-based search. Across large data sets it performs admirably, and we will certainly make it our first choice search solution in the future. For a use case where needs are simple and regular database queries might suffice, Elasticsearch may or may not provide any benefits.
No photo available

Feature Rating Comparison

BI Standard Reporting

QlikView
7.3
Elasticsearch
Pixel Perfect reports
QlikView
7.1
Elasticsearch
Customizable dashboards
QlikView
8.3
Elasticsearch
Report Formatting Templates
QlikView
6.3
Elasticsearch

Ad-hoc Reporting

QlikView
7.2
Elasticsearch
Drill-down analysis
QlikView
6.6
Elasticsearch
Formatting capabilities
QlikView
6.9
Elasticsearch
Integration with R or other statistical packages
QlikView
8.8
Elasticsearch
Report sharing and collaboration
QlikView
6.6
Elasticsearch

Report Output and Scheduling

QlikView
6.9
Elasticsearch
Publish to Web
QlikView
6.5
Elasticsearch
Publish to PDF
QlikView
7.5
Elasticsearch
Report Versioning
QlikView
6.5
Elasticsearch
Report Delivery Scheduling
QlikView
7.2
Elasticsearch

Data Discovery and Visualization

QlikView
5.5
Elasticsearch
Pre-built visualization formats (heatmaps, scatter plots etc.)
QlikView
6.1
Elasticsearch
Location Analytics / Geographic Visualization
QlikView
3.6
Elasticsearch
Predictive Analytics
QlikView
6.8
Elasticsearch

Access Control and Security

QlikView
7.7
Elasticsearch
Multi-User Support (named login)
QlikView
7.6
Elasticsearch
Role-Based Security Model
QlikView
7.5
Elasticsearch
Multiple Access Permission Levels (Create, Read, Delete)
QlikView
7.9
Elasticsearch

Mobile Capabilities

QlikView
6.8
Elasticsearch
Responsive Design for Web Access
QlikView
8.0
Elasticsearch
Dedicated iOS Application
QlikView
5.2
Elasticsearch
Dedicated Android Application
QlikView
6.4
Elasticsearch
Dashboard / Report / Visualization Interactivity on Mobile
QlikView
7.8
Elasticsearch

Pros

  • QV's #1 strength is the drag and drop visualization tools -- with just a bit of training, you can make some really nice looking charts
  • QV's #2 strength is the simplicity of the filtering. Other SQL languages might call this "linking" or database structure ... which can be a pain.... but QV makes this easy. Further, once the data is inside QV, the ability to FILTER the data using check boxes is completely intuitive and simple.
  • QV's #3 strength is its ability to work across platforms and integrate multiple data sources and multiple types of data. QuickBooks data is just one example of something that it can chew up with ease.
David Worrell profile photo
  • Super-fast search on millions of documents. We've got over 2 billion documents in our index and the retrieve speeds are still in the < 1-second range.
  • Analytics on top of your search. If you organize your data appropriately, Elasticsearch can serve as a distributed OLAP system
  • Elasticsearch is great for geographic data as well, including searching and filtering with geojson, and a variety of geospatial algorithms.
Anatoly Geyfman profile photo

Cons

  • Like a lot of software, QV starts with a blank page. If you are like me, you dive in without reading the instruction manual. Big mistake. There is a rigid stepwise process that you must follow to make it work....
  • I've never used anything quite as powerful as QV, so I cannot compare this to many other packages. ... but with 30 minutes of training and an hour of practice, you can be pretty proficient.
David Worrell profile photo
  • Elasticsearch is highly distributed, but it takes time to tune so you get the right performance out of your cluster.
  • The query language is not SQL, so it's not a straightforward conversion from an RDBMS to Elasticsearch for searching through data.
  • There are lots of ways to insert data into Elasticsearch, and some are better than others (batch vs. single insert). Need to experiment with your own data and environment.
Anatoly Geyfman profile photo

Likelihood to Renew

QlikView8.8
Based on 29 answers
Ease of use, ability to load from pretty much any data source. today I created an application that loaded time sheets from excel that are not in a table format. With Qlik's "enable transformation steps" I was able to automate loads of multiple spreadsheets and multiple tabs easily. Could not do that with any other tool.
Debbie Pyykkonen, MBA profile photo
Elasticsearch10.0
Based on 1 answer
We're pretty heavily invested in ElasticSearch at this point, and there aren't any obvious negatives that would make us reconsider this decision.
Aaron Gussman profile photo

Usability

QlikView9.8
Based on 6 answers
Once the data is loaded (which can range from simple to complex depending on the data set), it is relatively easy to create new charts/dashboards
Bill Chamberlain profile photo
Elasticsearch10.0
Based on 1 answer
To get started with Elasticsearch, you don't have to get very involved in configuring what really is an incredibly complex system under the hood. You simply install the package, run the service, and you're immediately able to begin using it. You don't need to learn any sort of query language to add data to Elasticsearch or perform some basic searching.If you're used to any sort of RESTful API, getting started with Elasticsearch is a breeze. If you've never interacted with a RESTful API directly, the journey may be a little more bumpy. Overall, though, it's incredibly simple to use for what it's doing under the covers.
No photo available

Reliability and Availability

QlikView9.8
Based on 4 answers
We have not had any downtime issues with the product nor uncovered any significant bugs
Bill Chamberlain profile photo
No score
No answers yet
No answers on this topic

Performance

QlikView8.6
Based on 4 answers
The speed of loading the data and working through the data visualizations is excellent
Bill Chamberlain profile photo
No score
No answers yet
No answers on this topic

Support

QlikView2.1
Based on 7 answers
Qlik does have a tendency to push back sometimes stating that the issue is not related to QlikView but the system it is hosted on
Debbie Pyykkonen, MBA profile photo
No score
No answers yet
No answers on this topic

In-Person Training

My team attended, but I cannot myself rate, but I think it was good as they've successfully launched a training program at our company themselves for users. It was 3-4 day training.
No photo available
No answers on this topic

Online Training

QlikView8.0
Based on 3 answers
Training was as expected. The demo environments tend to be more fully featured that our own environment, but the training was clear and well delivered.
Robert Goodman profile photo
No score
No answers yet
No answers on this topic

Implementation

QlikView7.4
Based on 13 answers
QlikView were here for a few days, and it was up and running. It was very fast.

Where it fell short, is they did the implementation in demo mode, and didn't initially work with us to help us scale. For example, should we consider a load balancer and multiple servers?. How much capacity can this environment handle from a data and user perspective. We had to learn on own by trial and error. We are bringing them in to do an architectural assessment, but we have to pay for this.

We are now bringing them back in for architectural assessment. It is a fee based engagement.
No photo available
Elasticsearch9.0
Based on 1 answer
Do not mix data and master roles. Dedicate at least 3 nodes just for Master
No photo available

Breadth of Deployment

Not applicable to our firm as we are small consulting firm.
Debbie Pyykkonen, MBA profile photo
No answers on this topic

Alternatives Considered

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
No photo available
We found Elasticsearch to be the fastest in querying text based data, allowing us to significantly speed up our APIs.
No photo available

Collaboration and Sharing

QlikView6.3
Based on 21 answers
Qlikview is better for desktop-based analysts or managers who already have qlikview desktop installed. Because of the proprietary file type and the lack of mobile-friendly reports, it can be difficult to have reports on the fly. Having "global" reports is useful when using the server version, however for desktop-only clients, sharing and versioning can be difficult if users have to physically/email share the reports/dashboards.
No photo available
No score
No answers yet
No answers on this topic

Data Integration

QlikView8.9
Based on 21 answers
Because qlikview acts more similar to a SQL database than spreadsheet/Excel software, it is great and adding new data sources and updating data from varied data sources such as OBDC-compliant databases, CSV, and Excel files. It can also connect to other software via export or OBDC connection. The script file allows data cleaning and ETL all in one location and across the entire data field.
No photo available
No score
No answers yet
No answers on this topic

Return on Investment

  • For us the investment value is related to the change in working practices and desire to share rich-content with our stakeholders.
  • QlikView is a good product and does what it says however the overhead of ad-hoc reporting remains.
No photo available
  • Elasticsearch has allowed us to shave off many (> 100 is some cases) milliseconds from our API response times.
  • Elasticsearch coupled with Kibana has allowed us a whole new level of visibility into our log data.
No photo available

Pricing Details

QlikView

General
Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Optional
QlikView Editions & Modules
QlikView
Edition
QlikView Desktop
Free1
QlikView
Custom2
1. Personal Edition
2. Per License
Additional Pricing Details
On an perpetual license basis, based on server plus number of users. Contact vendor for pricing.

Elasticsearch

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Elasticsearch Editions & Modules
Elasticsearch
Additional Pricing Details