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

Personnel productivity


Human Resources costs can represent up to 70 to 80 percent of the total cost of doing business (Lawler and Boudreau 2012). Our first goal is to analyze headcount, payroll, and how much revenue (or profit) we generate per employee and payroll dollar spent.

Tip

As an HR analyst, I want to discover who our most productive teams are so that I can share their practices with the rest of company.

We start our analysis by comparing headcount and payroll. As these amounts use a different scale, we use the left axis of a dot plot chart for headcount and the right axis for payroll. Before beginning the following exercise, we import this chapter's exercise files into the QDF as we did in Chapter 2, Sales Perspective.

Exercise 7.1

  1. In 1.Application\HR_Perspective_Sandbox.qvw, let's create a combo chart that measures headcount and payroll by year-month, as follows:

    Dimensions

    Details

    Label

    Value

    Year-Month

    Year-Month

    Expressions

    Label

    Value

    Headcount

    count(distinct [Headcount...