Qlikview is used as a data summarization tool for operational risk. The software sits on top of our database to allow the business to get insight into their data. We use it almost as someone might use a pivot table in Excel. We have preset pivots and charts that are updated relatively real-time as data is fed into the database.
The only other vendor product that I have worked with that provides a similar experience to Qlikview is Tableau. I would recommend Tableau if your use case is to build a fixed dashboard. You can share reports for free without needing to buy additional licenses. I would recommend Qlikview if your users are looking for a more interactive experience. They can create new objects to represent the data which can't be accomplished as easily in Tableau.
Data sourcing is easy on Qlikview if your data model is relatively simple. It does not handle multiple level relational data models or cube data models well. Feed data to Qlikview real-time is difficult.
It is well suited for creating simple dashboards. Larger data models will require significant back-end development to make up for QlikView's lack of front end caching. QlikView is a much better alternative than creating Excel pivot tables powered by macros. Its security settings, scalability, and stability surpass anything that can be built in Excel.