Radar Chart in QlikView

The Radar Chart in QlikView is very useful to visualize the numeric data. We can call the QlikView Radar Charts as the Line Charts where X-axis values wrapped in 360 degrees.

In this article, we show how to Create a Radar Chart in QlikView with example. For this QlikView Radar Chart demo, we use the data present in the following Excel table.

Excel File 1

From the screenshot below, see that we are loading the above specified excel sheet into the QlikView, and use the same for Radar chart.

Load Excel File 2

Create a Radar Chart in QlikView

In this example, we create a QlikView Radar chart for all the Countries and the corresponding sales amounts present in our data source. We use the Country Column as the dimension data and the Sales Amount expression to do this.

We can create a QlikView Radar chart in multiple ways: Please navigate to Layout Menu, select the New Sheet Object, and then select the Charts.. option.

New Sheet Object 3

Another approach is to Right-click on the Report area. Next, please select the New Sheet Object from the context menu, and then select the Charts.. option.

Choose New Sheet Object 4

Either way, it opens a new window to create a Radar Chart. From the below, see we assigned a new name called Radar Chart Example to our chart and then selected the chart type as the Radar Chart.

Radar Chart in QlikView 5

Please select the Dimension column to use in the Radar chart. For this QlikView Radar Chart example, we are adding the Country dimension to the used dimension section. It means all the Country names display in 360 degrees round. Refer to Import data from Excel to QlikView article to understand importing the excel tables into QlikView.

Add Dimensions 6

Clicking the Next button opens the Radar Chart Expression page. On top of that, a popup Edit Expression window opened. Use this window to write the custom expression or select the Columns.

From the below, see we are writing an expression under the Expression OK section. If you do not know how to write an expression, Please select the Field as Sales Amount, Aggregation as Sum, and click the Paste button.

Radar Chart in QlikView 7

Click the OK button to close the edit expression window and then click the Next button.

Radar Chart in QlikView 8

The Radar Chart Sort page is useful to specify the sorting order for the Country dimensions. In this example, we sort the Country in Ascending order.

Radar Chart in QlikView 9

The next page changes the look and style of a Radar chart. Here, we are changing the Plot Color Style to Light Gradient.

Radar Chart in QlikView 10

The QlikView Radar Chart Presentation page changes the Presentation. For example, we can change the Bar settings, enable scrolling axis, etc.

Radar Chart in QlikView 11

Axes page is useful to change the Axis Color, Scale, and we can change the Scale lengths (Minimum value, Maximum Value etc)

Radar Chart in QlikView 12

The QlikView colors page is useful to change the Color pattern of the Radar chart. Try to mix different options.

Radar Chart in QlikView 13

Next, we are formatting the Expression value. As we all know that the Sum of Sales Amount is money, so we are selecting the money.

Radar Chart in QlikView 14

The Radar Chart Font page changes the Font family, style, and font size as per requirements. From the screenshot below, see that we changed the Font = Rockwell, and Font size to 11.

Radar Chart in QlikView 15

The layout page provides the shadow effects to the Radar chart, or apply the custom theme by clicking the Apply Theme button. From the screenshot below, see that we changed the shadow intensity to Medium, and Border width to 3 (extra thickness to the border).

Radar Chart in QlikView 16

Use this Caption page to style the QlikView Radar Chart Caption. Here, we can change the Radar Chart background, position, color, and so on. From the below, we changed the Active Text color. Once done, click the Finish button.

Radar Chart in QlikView 17

Now, see our newly created Radar Chart in QlikView.

Radar Chart in QlikView 18

Through the above chart fulfilled our requirement. Let us add one more dimension to display the radar chart for each color, and country. To do so, we have to add color dimensions to the existing Radar chart. For this, right-click on the Chart and select the properties option from that context menu.

Radar Chart in QlikView 19

Clicking the properties option opens a new window called Chart Properties [Radar Chart Example]. Please navigate to the Dimension tab, and add Color to Used Dimensions.

Radar Chart in QlikView 20

Now, see the QlikView radar chart for each color and country

Radar Chart in QlikView 21

Please refer to QlikView Line Charts article.