What do you like best?
How easily it can connect to back end databases of all types. Thru scripting, it allows you to scrub data and create the necessary sort and selections fields even when there are weaknesses in the tables (missing fields).
A company looking for good BI software can download a free copy and do a proof of concept, all on their own, at zero cost. There are hundreds of YouTube videos to show you how to do everything along with extensive help and examples on the QlikView site. You can go into a project 100% sure of completion.
It is a very powerful tool!
What do you dislike?
The macros that you can add in the qvw's do not execute in the QlikView Console automation...only manually. A real flaw. Example: want to export a CSV file of a table in the qvw. This is about 3 lines of code in the macro screen. So easy. But the software won't execute macros with the console automation.
They know about it, and to my knowledge, are doing nothing about it.
I use nPrinting to accomplish this (but had to buy the software)
Recommendations to others considering the product
Go to the web site, download the free version and play with it. You will be amazed at the possibilities.
if you need to know how to do something, google it. There are several very good books on how to use the software also.
Heck I would use it for home budgeting and spend analysis if you don't own a business.
You will need to know a little SQL for the load scripting and be able to do complex expressions if you have complex calculations.
What business problems are you solving with the product? What benefits have you realized?
Everything you can think of.
We used it to migrate data from old software systems to new ones. So if you are getting ready for a migration, write all the outputs for tables the way you need the new fields to be with the new field names...use the files to test, then on the day of migration, just run all the jobs and import.
We link SQL, Mongo, XML, Excel tables from all sources including the web; rename files, scrub and display for any type of analysis.
The tables are so powerful and can display graphically as well as numerically.