Radar Chart in QlikView is very useful to visualize the numeric data. We can call the Radar Charts as the Line Charts where X-axis values are wrapped in 360 degrees. In this article we will show you, How to Create a Radar Chart in QlikView with example. For this we are going to use the data present in the following Excel table.
From the below screenshot you can observe that, we are loading the above specified excel sheet into the QlikView. I suggest you to refer Import data from Excel to QlikView article to understand the steps involved in importing the excel tables.
Create a Radar Chart in QlikView
In this example we will create a Radar chart for all the Countries, and it’s corresponding sales amount that are present in our data source. To do this, we are going to use the Country Column as the dimension data, and the Sales Amount expression.
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
Another approach is to Right-click on the Report area will open the Context menu. Please select the New Sheet Object from the context menu, and then select the Charts.. option.
Either ways, it will open a new window to create a Radar Chart. As you can see from the below screenshot, we assigned a new name called Radar Chart Example to our chart, and then selected the chart type as the Radar Chart
Please select the Dimension column that you want to use in your Radar chart. For this example, we are adding the Country dimension to the used dimension section. It means, all the Country names will be displayed in 360 degrees round.
Once you click on the Next button, an Expression page will be opened, and on top of that, a pop up window called Edit Expression will be opened. You can use this window to write the custom expression, or you can select the Columns.
As you can see from the below screenshot, we are writing an expression under the Expression OK section. If you don’t know how to write an expression, Please select the Filed as Sales Amount, Aggregation as Sum, and click the Paste button.
Click OK button to close the edit expression window, and then click Next button.
Sort page is useful to specify the sorting order for the Country dimensions. In this example, you can sort the Country in Ascending, or Descending order.
Next page is used to change the look, and style of a Radar chart. Here we are changing the Plot Color Style to Light Gradient.
Presentation page is used to change the Presentation of a Radar chart. For example, you can change the Bar settings, you can enable scrolling on axis etc.
Axes page is useful to change the Axis Color, Scale, and we can change the Scale lengths (Minimum value, Maximum Value etc)
Colors page is useful to change the Color pattern of the Radar chart. Try to mix different options
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.
Font page is used to change the Font family, style, and font size as per your requirements. From the below screenshot you can see that, we changed the Font = Rockwell, and Font size to 11
Layout page provide the shadow effects to your Radar chart, or you can apply the custom theme by clicking the Apply Theme button. From the below screenshot you can see that, we changed the shadow intensity to Medium, and Border width to 3 (extra thickness to border).
You can use this Caption page to style the QlikView Radar Chart Caption. Here you can change the background, position, color, and so on for your Line Chart. As you can see from the below screenshot, we changed the Active Text color. Once you done, click the Finish button
Now you can see our newly created Radar Chart in QlikView.
Through above chart fulfilled our requirement. Let me add one more dimension, to display the radar chart for each color, and country. In order to do so, we have to add color dimension to existing Radar chart. For this, right-click on the Chart will open the context menu. Please select the properties option from that context menu.
Once you click on the properties option, a new window called Chart Properties [Radar Chart Example] will be opened as we shown below. Please navigate to Dimension tab, and add Color to Used Dimensions.
Now you see the radar chart for each color, and country
Thank You for Visiting Our Blog