Other charts

Over the course of this chapter, we looked at the most common charts found within QlikView. There are, however, some charts that we did not use, and we will use this final section to take a quick glance at them. Do not worry though; with the knowledge you picked up earlier in this chapter you should have no problem creating these charts as well. Examples of these charts are also included on the Other Charts tab of this chapter's solution file.

Radar Chart

The Radar Chart can be used to depict information that is cyclical in nature. For example, the following screenshot illustrates the number of enplaned passengers per month. In this example you can clearly see that travel increases during the summer months:

Radar Chart

Mekko Chart

The Mekko Chart is basically a bar chart with the ability to handle an additional dimension. Our example, shown in the following image, displays the number of enplaned passengers by Flight Type and Year. The width of the bar is determined by the relative amount versus the total, considering the first dimension: Flight Type; and the segment distribution within the bar is determined by the relative amount versus the total, considering the second dimension: Year. Looking at this chart we can clearly see that most passengers are being transported on Domestic, US Carrier Only flights, and that the number of passengers transported is roughly equally distributed over the years.

Mekko Chart

Grid Chart

A Grid Chart can contain three different dimensions. In the following example, we've used the Year, Quarter, and Flight Type dimensions. The bubble size represents the number of transported passengers. By taking a closer look, and probably with some imagination, we can spot the same discoveries we made in the first two charts. Bubble sizes are bigger in Q2 and Q3, indicating increased travel during the summer. We can also easily see that most passengers are being transported on Domestic, US Carriers Only flights. Additionally, we can see how Q3 has been smoothly increasing over the last three years.

Grid Chart

Funnel Chart

A Funnel Chart is often used in sales reports to visualize the "sales funnel", that is, which sales opportunities are in which phase of the sales process. The following screenshot shows an example chart that shows the various stages in the sales process and how many clients are present in that phase:

Funnel Chart

Block Chart

A Block Chart can be used to display hierarchical information, by displaying blocks within blocks. In our example, the size of the block corresponds to the number of passengers that were transported. Each block represents a destination city, and they are all grouped into bigger blocks according to their corresponding countries.

In this example we can clearly see that the majority of passengers have arrived somewhere in the United States. Within the US, we can see that Atlanta, GA and Chicago, IL are the most popular destinations.

By comparing blocks within the chart, we can see that the combined total number of people traveling from US to Canada, Mexico, and the United Kingdom is smaller than the number of people traveling to Atlanta, GA.

Block Chart

Trellis Chart

The Trellis Chart is not really a separate chart, but a chart option that exists on all charts; with the exception of the straight tables and pivot tables. It creates a grid in which a separate chart is created for each distinct value of the first dimension. To facilitate easy comparisons between charts, each chart's axis uses the same scale.

In the following chart, we have created a chart with two dimensions: Flight Type and Month. We have enabled the Trellis Chart option for the first dimension. The result is a chart that shows, within a grid, a separate chart for each Flight Type. Each separate chart shows the Load Factor % per Month.

Trellis Chart

The Trellis option can be set by going into the Chart Properties of a chart. On the Dimensions tab you will find the Trellis button; clicking this brings up the Trellis Settings, shown in the following screenshot:

Trellis Chart

To create a trellis chart, we click on Enable Trellis Chart. Optionally, we can manually set the Number of Columns and/or Number of Rows options.

Note

With the exception of the trellis and the block chart, you will find that whenever you are thinking of using any of the charts (radar, mekko, funnel, or grid), there is usually a better solution that uses a bar, line, or scatter chart.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset