O'Reilly logo

QlikView Your Business by Lars Bjork, Charlie Leichtweis, Tammy Gibson, Oleg Troyansky

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4 Visualizing Sales Analysis in QlikView

In real life, developing QlikView applications follows an approach that begins with gathering business requirements, then planning the data model, then identifying data sources, and then loading the data into QlikView. The last step is building visualizations.

However, because we believe it’s better to learn simple QlikView techniques before proceeding to more advanced ones, this chapter describes the process of building visualizations before you learn data modeling and scripting. We will cover these topics in Chapters 5 and 6.

For this chapter, imagine that you are a business analyst. You need to build a Sales Analysis dashboard, but you don’t need to know how to load data into QlikView. We’ll assume that you’ve asked the trusted consultants from Natural Synergies to develop a data model, and you’ll use it “as is” for developing the analytic solution.

In the next few sections, you’ll build a simple yet effective Sales Analysis application, and in the process of doing so you will learn the following visualization techniques:

  • Developing list boxes and multi boxes to allow user selections
  • Building a page outline with text objects and line/arrow objects
  • Building simple charts
  • Comparing current year-to-date with prior year-to-date and applying other conditions to your aggregations
  • Building a professional-looking dashboard

Preparing the Environment and Getting Ready

In this section, you open the template document and make some ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required