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

The nuts and bolts of the Inventory dashboard


Now, we will look at the object components of the Inventory dashboard. When we click on the white area of our sheet object, we can see that again we have a container object, but this container only contains text and lines and two list boxes, one for the fiscal year and one for the fiscal month. What about the charts? Also, what is that looking like a complicated list box in the right-hand side quadrant?

The pivot table

When we open the properties of the object in the upper-right-hand side corner, the Inventory On Hand Report, we can see that the object is actually a Pivot Table. We have not worked with a Pivot Table object before:

Figure 7-5: Closeup of the Pivot Table icon on the General tab

Since this is the first time that we have worked with a Pivot Table, open Properties by right-clicking and choosing Properties in the context menu so that we can see what is unique about a Pivot Table object.

On the Dimensions tab, we can see that we are using...