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 sales analysis dashboard


We will now start looking at the components that make up the Sales Analysis dashboard so that we can leverage them to make improvements.

The group button

Although the text title on the left-hand side of the straight table (Segment Change in Revenue vs Last Year) does not change, you can change what is displayed in the straight table, Segment Changes in Revenue, using the Group button in the upper left corner of the table (see Figure 5-3):

Figure 5-3: The Dimension Selection button in the straight table

This button looks like a circular arrow; if you hover over it, the word Cycle pops up in a box. The button allows you to scroll through group measures selected for the table. Provided at least two or more expressions are available to create a group, the Group button can be used in transforming merged group expressions of dimensions or measures into one or more cyclic groups.

In the QlikView layout, you can cycle through the expressions belonging...