Book Image

Qlikview for Finance

Book Image

Qlikview for Finance

Overview of this book

This book is an effective step-by-step tutoring guide for financial analysis using Qlikview. It begins by teaching you the crucial concepts of Qlikview Finance to help you develop an effective understanding of financial data analysis and finance. The book then goes on to cover real-world, practical examples on the use of Qlikview for financial planning and analysis, expense management, risk management, and more. Moving on, topics such as Asset Management QlikView Dashboard and Retail Sales Analysis are covered in a strategic way. We then shift the focus to deal with the concepts of Inventory, Supply Chain, and Plant Coverage Dashboards. The book then reaches its conclusion by dealing with ways to share your QlikView insights. By the end of this book, you will have a good understanding of how to use Qlikview for numerous applications in finance.
Table of Contents (18 chapters)
QlikView for Finance
Credits
Disclaimer
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Analysis of the expenses dashboard display


The Expenses dashboard is another four-quadrant dashboard with a Pivot Table on the upper right-hand side, surrounded by three graphs analyzing essentially the same data in different formats. The pivot table is organized by the Cost Center group and reports in thousands, as the title clearly states. It is well-organized with fairly standard income-expense statement section type columns. Therefore, we can see the 2011 expenses as compared to the budget and the previous year, with the variance in both dollars and percentages. The unfavorable variances are the positive numbers shown in red; those columns must be formatted in Properties so that the text for those numbers is set to red when the value is greater than zero. This is just the opposite of the setting used in the previous chapter covering the Order Details tab. My preference would be to only have the pivot table and to have more detailed information loaded so that we can drill-down on the...