Book Image

Mastering QlikView Data Visualization

By : Karl Pover
Book Image

Mastering QlikView Data Visualization

By: Karl Pover

Overview of this book

Just because you know how to swing a hammer doesn't mean you know how to build a house. Now that you've learned how to use QlikView, it's time to learn how to develop meaningful QlikView applications that deliver what your business users need. You will explore the requirements and the data from several business departments in order to deliver the most amazing analysis and data visualizations. In doing so, you will practice using advanced QlikView functions, chart object property options, and extensions to solve real-world challenges.
Table of Contents (18 chapters)
Mastering QlikView Data Visualization
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Working capital data model


The working capital data model can be constructed in a variety of ways. The most important feature of the data model is its ability to accumulate account balances over time. In Chapter 3, Financial Perspective, we accomplish this by adding an as-of calendar. However, we can also create a model that uses periodic snapshots and avoid accumulating individual transactions after every user selection. A periodic snapshot is a recurring event that saves a copy of the data at the end of every day, week, or month.

Tip

Even though we may end up only using monthly snapshots in a QlikView application, it is wise to take a daily snapshot of the data and save it in QVD files in case business requirements change.

In this chapter, we will use a periodic snapshot to measure following events in the data model:

  • Month-end inventory balances by item and warehouse over three years

  • Day-end inventory balances by item and warehouse over the last the last three months

  • Month-end balances of A...