I can tell you something about Qlikview and no.. I don't work for them.

The organisation I work for used Qlikview for about 4 years as a reporting tool for a bespoke Complaints system that was clocking up about 12000 complaint/adjudications per year with all the associated records and complaint history. The only reason we don't use this tool anymore is because that division was hived off to another organisation. I also seem to recall that at least one large energy company in the UK used to use it for showing KPI's.

It is in my experience an extremely effective and efficient tool that gives the end users the ability to dynamically "click" on items in the report to pivot, zoom in or drill down and hence is very popular with these end users. The graphics are quite nice too 😉

It can be used as a web server enterprise type tool (like SSRS) so is accessible from web browsers or via client workstation installs.

The caveats with Qlikview are:

To pull the data appears to be simple, it is as Qlikview uses fairly standard TSQL.. but Qlikview will make quite a few assumptions on this data so most of the struggle is to mold the data you pull in so that Qlikview makes the correct one. This can involve quite some time messing around with queries and the Qlikview scripting language, consequently it requires a fairly good knowledge of Qlikview itself as well as some design sense.

It is hard to develop complex dashboards unless you know Qlikview quite well - you'll need to go on a course or two or read a lot of books/how-tos and experiment with the product.

The end users of your dashboard can get lost as the Qlikview interface though simple is not something they'll be used to, they will need some basic training on how to use the end product of your design efforts.

If using the web browser client you will have to have the permissions to download and install and activex component on all your clients for full functionality luckily this is an msi so can be published from AD.

In my experience with it (I've not used it for about 1-2 years now so am getting a bit blurry on it) it gives you snapshots not real time data, but you can set this to refresh on a regular basis.

Check out the Qlikview site - just because it has only 1% of the market share doesn't mean it isn't any good. I've used a variety of reporting tools and IMO Qlikview is much better than most but I'd still recommend you get a Qlikview consultant to initially get you up and running while you learn how to use the product. They're still trying to break into various markets so you may be able come to some sort of arrangement with them or their re-sellers.. especially to demo the product using some of your data.