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.

Related Content you might be interested in

Current Title:

Small book image
Mastering QlikView Data Visualization
Karl Pover
Apr, 2016 | 294 pages
No titles found
Table of Contents (18 chapters)
Mastering QlikView Data Visualization
Mastering QlikView Data Visualization
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Data Visualization Strategy
Data Visualization Strategy
Data exploration, visualization, and discovery
Data teams and roles
Agile development
QlikView Deployment Framework
Summary
2
Sales Perspective
Sales Perspective
Sales perspective data model
Customer stratification.
Customer churn
QlikView extensions and the cycle plot
Governance – design template
Summary
3
Financial Perspective
Financial Perspective
Financial perspective data model
AsOfCalendar
Income statement
Balance sheet
Cash flow statement
Summary
4
Marketing Perspective
Marketing Perspective
Marketing data model
Customer profiling
Summary
5
Working Capital Perspective
Working Capital Perspective
Working capital data model
Rotation and average days
Working capital breakdown
Summary
6
Operations Perspective
Operations Perspective
Operations data model
On-Time and In-Full
Planning in QlikView with KliqPlan
Summary
7
Human Resources
Human Resources
Human resources data model
Personnel productivity
Personnel productivity breakdown
Personal behavior analysis
Summary
8
Fact Sheets
Fact Sheets
Customer fact sheet consolidated data model
Customer Fact sheet Agile design
Customer Fact sheet advanced components
Customizing the QlikView User Experience
Summary
9
Balanced Scorecard
Balanced Scorecard
The Balanced Scorecard method
The Balanced Scorecard consolidated data model
The Balanced Scorecard information dashboard design
Creating the filter pane bubble
Measuring success with XmR charts
Summary
10
Troubleshooting Analysis
Troubleshooting Analysis
Troubleshooting preparation and resources
Reporting issues
Common QlikView application issues
Summary
11
Mastering Qlik Sense Data Visualization
Mastering Qlik Sense Data Visualization
Qlik Sense and QlikView developers
Visualization extension examples for cross-selling
Plan to master Qlik Sense data visualization
Summary
Index
Index

Financial perspective data model

The data model for our financial perspective is similar to our sales data model. Let's load the data model and review it.

Exercise 3.1

For this exercise, you need to perform the following steps:

  1. In the Ch. 3 folder of the book's exercise files, copy the container called 1002.Financial_Perspective to the QDF folder located on your computer. By default, the QDF folder will be C:\Qlik\SourceData.

  2. In the QDF folder, open the VariableEditor shortcut in the 0.Administration container.

  3. Click Container Map Editor.

  4. In the container map table, go to first empty line, and under the Container Folder Name column, enter the name of the new container that we just copied, 1002.Financial_Perspective, into the input field.

  5. Continue along the row and enter the Variable Prefix as Financial and the Container Comments as Container for Financial Perspective.

  6. Click the Update Map and create Containers button located at the top-left of the container map table, and when prompted, click...

Previous Section
End of Section 2
Next Section