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

Display sales as a KPI


In our previously loaded sample data from Chapter 1, Getting That Financial Data into QlikView, sales is a grouping in the AcctGroup column and is a credit. It comes directly from the source system as a negative so that, when everything is summed up, we get a trial balance. That is why we could see the out of balances in our first tab. Sales will have to be multiplied by minus one (-1) in order for it to appear as a positive number. Also, we would like to have a target number to compare with Sales.

Note

There are two additional sample data Excel spreadsheets available for download from your account at http://www.PacktPub.com that are used in this chapter. One is named Target.xls and the other is named IS3yr.xls.

Our target is another Excel workbook named Target.xls that is available for download, or you can create your own workbook to load. The one available for download has this data:

Company

Target

Cheyenne Manufacturing

140000000

American Distribution

0

Cheyenne...