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

Adding data sources


Now, reopen Executive Dashboard.qvw in the examples. Choose File | Edit Script.

Loading from another QlikView document

Although there is not much left to learn from the actual scripts in the CFO executive dashboard, we can see from the very first statement in the script that we are loading from another QlikView document with the same name em dash except with lowercase letters. The following is the first statement in the script:

Binary [executive dashboard.qvw];

The binary statement is used for loading the data from another QlikView document. It does not load the layout information or variables. Only one binary statement is allowed in the script, and it can only be put as the first statement of a script. You can use relative locations, and there is a checkbox to get QlikView to generate a relative location statement. This allows you to move your QlikView operations to folders on another computer or another server without extensive editing of script load paths.

Loading from...