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 What If? dashboard


We will now examine the What If? dashboard to see what ideas it can generate for our own QlikView documents. The What If? tab is located on the right-hand side of the Sales Analysis tab. It is a reasonably simple example of an input multiplied by measures to display the results. The Slider changes what shows in the Input Box, but the Input Box does not always change the Slider, especially if the number entered is outside the slider range. The sliders look as if you can pick an interval between one and five or between five and ten but, in reality, you are limited to intervals of 5 percent. Manually, you can click in the interval display box and then click on the ellipses (…). This will pop up an Expression Wizard page, where you could enter an expression or just an intermediate number, such as 2.5 or -17.

We can also see that the Selection layout is the same as the other dashboards. Again, this consistency is a good choice.

So, how do the What If...